Get Free Trial

Using "% difference"

Iouri Prokhorov 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) 5×3, 5×4, 5×5 gives three values, but corresponding difference 5×7, 5×8, 5×9 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.


3 answers

Tanya Gryshko Tanya Gryshko Flexmonster 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: For example, Company A has Sum of Revenue for January as 15395, for February as 57305730 is by 62% less than 15395, which is displayed in this JSFiddle.
Please let me know if you have more questions.

Iouri Prokhorov 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?

Dmytro Zvazhii Dmytro Zvazhii Flexmonster 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: 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.

Please login or Register to Submit Answer