I created a result path calculation to show the evolution of Solved tickets in the past two years. When I finished, the query stopped showing the absolute values. I can only see the manipulated results as in the image below. How can I add a column in the query that shows the absolute values alongside the manipulated results?
The result path calculation shows the evolution between two values and when it's used, it replaces the absolute value with the manipulated results.
This article explains how to work around this behavior and display the original values.
- Duplicate the metric of your query
- Add the result path calculation
- Hide the empty columns and add arrows to the query
In the example of this article, we use the Solved tickets metric and Ticket Solved - Year as an attribute filtered by the last two years. However, use this workflow for any other metric or attribute.
Duplicate the metric of your query
- In the metric panel, click the metric in your query. In this case, Solved tickets.
- Select the eye icon and the Standard calculated metric panel will open.
- Select Duplicate. Select the same dataset as the one used for your query. In this example, it is Support: Tickets.
- Select Ok. It should take you back to your query
- In the Metrics panel, click Add.
- From the list of metrics, choose Calculated metrics > Solved tickets Copy, then click Apply.
You should have this result:
Add the result Path Calculation
- In the result manipulation menu (), select Result path calculation.
- In COUNT (Solved Tickets Copy), choose the below options:
- Pattern > % of difference.
- Path > On columns
- Reference > Previous element
- Select Apply.
This is the result:
Hide the empty columns and add arrows to the query
- In the query, go to Chart Configuration () and select Columns.
- Hide the second column by clicking the Visible () icon in Column 2.
- Select the checkbox Arrow in the Column 4 row.
- In the query, click Solved tickets Copy and change the title to Change.
This is the final result: