The Quick Functions let you apply powerful calculations on measures to highlight the key indicators in a dashboard.
In Wyn Dashboards, there are a variety of predefined quick functions that makes it easier for you to apply complex calculations on measures. You can also modify the quick functions as per your requirements to achieve a specific result. These functions include date based, ranking calculation, percentile calculation, running calculation, moving calculation, each described below in detail.
Date Based Functions
With Date Based functions, you can create comparison visuals between the data in different date ranges, like year-over-year, month-over-month, etc., or display the values for a specific date range in a pre-defined offset like last year data by months.
Let's say, if you choose Past Quarter (under Past Value) for the date based function, then each quarter will show the value for the last quarter, like quarter Q3 shows the value for quarter Q2, quarter Q2 shows the value for quarter Q1, while quarter Q1 will not display any value because no data is left.
Use Ranking Calculation to rank the data values in a specified range within the scenario. When you apply the function, the data values within the scenario are replaced with the corresponding ranking values.
For example, we applied a ranking calculation in a scenario to rank the POSs based on the total revenue. The first rank in the scenario indicates the POS with the largest revenue value, that is, Web, while the fifth rank indicates the POS with the smallest revenue value, that is, Fax.
Refer to the following table that describes the different fields available in the Ranking Calculation dialog.
Percentile Calculation displays the value below which a certain percent of observations fall. It expresses each measure value as a percentage of rows, columns, axis (category), legend (series) etc. based on your selection.
The below chart scenario displays each month's tickets as a percentage of the total tickets for all the months.
Apply Running Calculation to compute the cumulative sum of a measure within a scenario, generated by adding the new data value to the previous data value. You can also specify the type of aggregation method you want to use to summarize the data values in Running Calculation like sum, average, max, min, and count.
The following chart scenario calculates the total running sum of all the tickets for each month, starting from January till December.
Refer to the following table that describes the fields available in the Running Calculation dialog.
As the name suggests, Moving Calculation is the calculation that moves along the time scale such that the old value is dropped when the new value becomes available. You can specify the aggregation method of your choice when defining the Moving Calculation for a measure like sum, average, max, and min. This quick function helps you to analyze and determine the overall trends in the data more clearly.
For example, a '4 - day moving sum' is the 4 - day sum of tickets as shown in the following image. The moving sum for day 4 is day 1 + day 2 + day 3 + day 4, that is, 152 + 139 + 138 + 141 = 570. While for day 5, it is day 2 + day 3 + day 4 + day 5, that is, 139 + 138 + 141 + 156 = 574, and so on. This implies that as we move forward, the old value is replaced with the next new value.
The following table describes the various fields that you can set in the Moving Calculation dialog.
To remove a quick function applied to a measure that you no longer require, select 'Original Value' as shown. It returns the original measure value in the scenario.
In the Data Binding tab of the selected scenario, go to the measure's settings under the Value section and select Quick Functions.
Choose a quick function that you want to apply to the measure. For example, select 'Running Calculation' to calculate the running sum of the tickets in the scenario.
In the Running Calculation dialog, set the Calculation Type to an appropriate aggregation method from the list, for example, Sum.
Set Along to a suitable option from the list like total chart, trellis rows, trellis columns, etc. depending on your requirements.
Click OK to save the changes.