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



document.addEventListener('DOMContentLoaded', function () {
const toggleBtn = document.getElementById('master-toggle');

toggleBtn.addEventListener('click', function () {
const action = this.getAttribute('data-action');
const headers = document.querySelectorAll('.accordion');

headers.forEach(header => {
const isActive = header.classList.contains('active');
const panel = header.nextElementSibling; // Grabs the corresponding .panel container

if (action === 'expand' && !isActive) {
// Open it by simulating a standard click
header.click();
} else if (action === 'collapse' && isActive) {
// Close it by simulating a standard click
header.click();
}
});

// Flip button text and states
if (action === 'expand') {
this.setAttribute('data-action', 'collapse');
this.textContent = 'Collapse all tabs';
} else {
this.setAttribute('data-action', 'expand');
this.textContent = 'Expand all tabs';
}
});
});
Duplicate the metric of your report

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


Add the result path calculation

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


Select Apply.


Hide the empty columns and add arrows to the report

In the report, go to Chart Configuration ( ), then 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 report, click Solved tickets Copy, then change the title to Change.


