Month - on - Month comparison

[Jan_van_Ansem]

Hi Lumira guru's,

I have daily sales transactions which I want to analyse.

One of the angles I want to highlight is the Month - on Month comparison.

I can show the graphs for sales by month, but what would be more interesting is to show the difference between 'this month' and 'previous month'.

I've been trying to work this out but failed. I can create a new dimension using a calculation and time/date functions, (add month) but I don't see how that is going to help me.

When looking at the options to calculate a new measure I don't see anything that would help me to calculate M-o-M or Y-o-Y.

Is it possible to calculate monthly difference, monthly % increase, etcetera, in Lumira or should I do this outside Lumira in a different tool (my data is currently coming from Excel) and only use Lumira for visualization, not calculation?

Thanks for your thoughts,

Jan.

[Former Member]

hi Jan Van Ansem,

After Importing data from Excel

In Lumira take Month on X-Axis and Doctotal On Y- Axis As followes:

then you can Track difference between previous months

Hope helpfull.

Thanks and Regards

DEV

[Jan_van_Ansem]

Thanks DEV,

I know how I can plot values.

If June is $ 600 and May is $ 400 I want to show a diagram showing June M-o-M = + $ 200.

It looks like I have to derive M-o-M before loading my data to Lumira?

Jan.