Process Charts
Explore ProcessMind chart types and customization options to visualize data effectively and identify trends. Elevate your data analysis with intuitive charts.
On This Page
Expressions
Expressions
ProcessMind’s expression capabilities allow for rich text generation and dynamic content within your dashboards. By leveraging expressions, you can create more engaging and informative visualizations that adapt to your data. Since the content can change based on user interactions or data updates, expressions provide a powerful way to keep your dashboards relevant and insightful. In this guide, we will cover some examples and possible notations for using expressions effectively.
Basics
For basic usage, you can use expressions to reference metrics and attributes directly within your text. This allows you to create dynamic content that updates automatically as your data changes.
Example 1: Nr of cases vs Total Nr of Cases
I want to display the active nr of cases vs total number of cases. The expression would look like this:
Nr of cases in view: ${metric} / Total Cases: ${total}
Where ${metric} is the current metric value and ${total} is the total number of cases.
Example 2: Nr of cases not included
I want to display the nr of cases subtracted from the total:
Nr of cases not included: ${total - metric}
Where ${metric} is the current metric value and ${total} is the total number of cases.
Example 3: Percentage of cases using a function
I want to display the percentage of cases in view compared to the total:
Percentage of cases in view: ${formatPercentage(metric)}
Where ${metric} is the current metric that is set to cases.
Available Functions
ProcessMind supports a set of functions that can be used inside expressions to perform calculations, formatting, and dynamic lookups. You can combine these functions with your metrics and attributes for more powerful text outputs.
| Function | Description | Example |
|---|---|---|
round(value, decimals?) | Rounds a number to the nearest integer, or to a specified number of decimal places. | ${round(metric, 2)} → 123.46 |
power(base, exponent) | Raises a number to a power (same as pow). | ${power(2, 3)} → 8 |
pow(base, exponent) | Alias for power. | ${pow(metric, 2)} |
sqrt(value) | Returns the square root of a number. | ${sqrt(metric)} |
abs(value) | Returns the absolute value (removes negative sign). | ${abs(metric)} |
ceil(value) | Rounds a number up to the nearest integer. | ${ceil(3.2)} → 4 |
floor(value) | Rounds a number down to the nearest integer. | ${floor(3.8)} → 3 |
exp(value) | Returns Euler’s number e raised to the power of the value. | ${exp(1)} → 2.718... |
log(value) | Returns the natural logarithm (base e). | ${log(metric)} |
mod(dividend, divisor) | Returns the remainder after division. | ${mod(10, 3)} → 1 |
formatDate(date, format?) | Formats a date into a human-readable string. Accepts optional format patterns. | ${formatDate(created_at, "YYYY-MM-DD")} |
formatDuration(ms) | Converts a duration in milliseconds into a human-readable string. | ${formatDuration(metric)} → 3d 4h 5m |
formatPercentage(value) | Formats a decimal as a percentage. | ${formatPercentage(metric)} → 75% |
getVariable(name) | Retrieves the value of a user-defined variable. | ${getVariable("Case Id")} |
Tip: Functions can be nested or combined with arithmetic.
Example:
${formatPercentage(round(metric / total, 2))}
This will calculate a ratio, round it to 2 decimals, and format it as a percentage.
Closing Remarks
This flexibility of combining metrics, attributes, operators, and functions allows you to create dashboards that do more than just display numbers they tell a story. By using expressions, you can build highly dynamic text and calculated insights that adjust automatically as your users filter or explore the data.
Whether you’re showing percentages, highlighting KPIs, or formatting values for readability, expressions help you keep your dashboards informative, actionable, and visually engaging all without writing custom code.
Use these tools to guide your users toward meaningful insights, surface trends, and make data easier to understand. With a bit of creativity, your dashboards can evolve into interactive narratives that empower better decision making.