asked on August 30, 2018
Hello guys,
I am trying to figure out how the "% difference" option works. I am getting % difference values but I cannot understand what it is calculating. For example:
(using notation row x column) 5x3, 5x4, 5x5 gives three values, but corresponding difference 5x7, 5x8, 5x9 clear does not give the correct difference between those columns. Am I using this correctly, and what is it measuring? If I am not, how would I achieve the desired effect.
Thanks
Iouri
⋅ August 31, 2018
Hello, Iouri,
Thank you for writing to us.
"%difference" expresses the percentage change from one item to another item.
Please have a look at the following example: http://jsfiddle.net/flexmonster/rkprvhhs/937/. For example, Company A has Sum of Revenue for January as 15395, for February as 5730. 5730 is by 62% less than 15395, which is displayed in this JSFiddle.
Please let me know if you have more questions.
Regards,
Tanya
⋅ August 31, 2018
Thanks Tanya, so you mean that % difference works on Rows and not columns? If so, how does it make work on columns?
⋅ September 3, 2018
Hello, Iouri,
Thank you for your feedback. If you need to have % difference for the columns please change the slice according to the following example: http://jsfiddle.net/flexmonster/rkprvhhs/960/. The "Measures" part should be placed into the rows part:
"rows": [
{
"uniqueName": "Month"
},
{
"uniqueName": "[Measures]"
}
]
Please let us know in case of any other questions.
Regards,
Dmytro
