Adding percents to a line graph of two data points
Hello Community,
Currently, I have a pie chart report showing two data points; one data point is qty of tickets hitting an SLA, and the other data point is qty of tickets not hitting the SLA. With the pie chart, we receive a % for each.
i.e. Data point 1 is 305 and data point 2 is 32, so the percents on the pie chart are 91% and 9%.
This report is going over a single week time frame, but I want to expand this to show each week for the last 8 weeks, on a line graph, with the percentages. Right now when I expand this report and modify to a line graph, I am only able to get the numbers, i.e. 305 and 32, but not the percentages.
Any insight would be helpful on this.

After additional thought, I believe I handled this issue.
The percents for the pie chart were being calculated via a + b / a and a + b / b, as one could expect. In order to get the line graph to function properly, I needed to calculate new metrics derived from the prior SLA metrics that would account for each percent.
From there, configure the report's How from Week (SunSat)/Year (Event) as well as filtering for the desired range by Week (SunSat)/Year (Event). This then allowed me to have an 8week report showing both percentage values. 
That's awesome!
Thanks for sharing the solution Alex :)
This will be super useful to others looking to run the same report.
Cheers!
댓글을 남기려면 로그인하세요.
2 댓글