Forum Discussion
visualize percentage point difference between two bars that represent two calculated measures
Hi all.
I have a problem visualizing the percentage point difference between two columns that display calculated percentages. What I need to do is to show percentages of customer satisfaction on different items in two different years - and the percentage point difference between these years for each item.
I first calculated the percentage of positive replies on each item, and then used the "same period last year" to get the values on each of the years. Finaly, I did a simple subtraction of the two measures. This gives me the table in the bottom here, which returns the right calculations. Problem is, when I try to disply the difference column in a bar chart, I get wrong returns
Below I have listed the "false" results and then a table with the numbers I want to disply. Does anyone know how to get it right (fingers crossed and many thanks!)?
False results
| Item name,DL-Values,Difference | ||
| DL1,"64,8 %","-0,78 %" | ||
| DL2,"55,6 %","0,73 %" | ||
| DL3,"61,4 %","2,91 %" | ||
| DL4,"64,8 %","-1,03 %" | ||
| DL5,"78,3 %","-1,44 %" | ||
| DL6,"77,4 %","-2,53 %" | ||
Correct table:
| Item | Year | Value | Difference |
| DL1 | 2021 | 65,60% | |
| DL1 | 2022 | 64,60% | -1,00% |
| DL2 | 2021 | 54,80% | |
| DL2 | 2022 | 55,90% | 1,10% |
| DL3 | 2021 | 58,50% | |
| DL3 | 2022 | 62,90% | 4,40% |
| DL4 | 2021 | 65,90% | |
| DL4 | 2022 | 64,30% | -1,60% |
| DL5 | 2021 | 79,70% | |
| DL5 | 2022 | 77,50% | -2,20% |
| DL6 | 2021 | 79,90% | |
| DL6 | 2022 | 76,00% | -3,90% |
