Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Using "% difference"

Resolved

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.

Thanks
Iouri

Attachments:
flexmonster_query.tif

Public
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

Public
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?

Public
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