Forum Discussion
Month on Month - % difference
Hi,
I have a series of facebook posts over a couple of years (by post date), including key stats - reach, impressions, engagement etc. - and am after some help creating month-on-month calculations.
I'm including some trend graphs (with data from 2016-present) , but also some card visuals with the just the latest month (eg: volume of published posts in Jan) and would like for these to show Month-on-Month variance %.
Anyone able to help?
Many thanks!
Sonia
17 Replies
- AnonymousNot applicable
Hi Sonia,
Did you try the quick measure Month-over-month change?
- AnonymousNot applicable
Hi,
I'm not sure, what is the quick month on month measure ?
- AnonymousNot applicable
If you right click on your column name, you will see an option to create a New Quick Measure. Refer to the screenshot below.
You may have to mark your date table as Custom Date table with no duplicate values.