How do I add a column in my report for the result path calculation?

How can I add a column in my report for the result path calculation?

I created a result path calculation to show the evolution of Solved tickets in the past two years. When I finished, the report stopped showing the absolute values. I can only see the manipulated results in the image below. How can I add a column in the report that shows the absolute values alongside the manipulated results?

The result path calculation shows the evolution between two values. When you use it, it replaces the absolute value with the manipulated results.

See this workaround to display the original values.

This article uses the Solved tickets metric and Ticket Solved - Year as an attribute filtered by the last two years. Use this workflow for any other metric or attribute.

Expand all tabs

Duplicate the metric of your report

1. In the metric panel, click the metric in your report, such as Solved tickets.
2. Select the eye icon to open the Standard calculated metric panel.
3. Select Duplicate, select the same dataset as the one used for your report, such as Support: Tickets, then select Ok.
4. In the Metrics panel, click Add.
5. From the list of metrics, choose Calculated metrics > Solved tickets Copy, then click Apply.

Add the result path calculation

1. In the result manipulation menu (), select Result path calculation.
2. In COUNT (Solved Tickets Copy), choose the options below:
   • Pattern > % of difference
   • Path > On columns
   • Reference > Previous element
3. Select Apply.

Hide the empty columns and add arrows to the report

1. In the report, go to Chart Configuration (), then select Columns.
2. Hide the second column by clicking the Visible () icon in Column 2.
3. Select the checkbox Arrow in the Column 4 row.
4. In the report, click Solved tickets Copy, then change the title to Change.