It is absolutely possible but strongly depends on your data and the level of aggregation you use in your view.
If you only have that period in rows as the only dimension used then you could use a calculation like
to reference previous period
Please consider sharing a sample twbx so that we can help more
I've attached a link to a blog post I've recently written on this very subject. It should show multiple ways of comparing two periods and the workbook will show you how I've then took values from both periods and compared them to see a change/growth/which is bigger.
I had a look at your solution - pretty neat. If you add 'latest available period in data' option it would be more general and dynamic. One thing to note is that this method does not allow to partition or filter the data in the view by date periods and only one period can be analyzed/presented.
thank you for your suggestions; unfortunately I'm still here with my unsolved calc.
I've attached an extract of the data.
All I'm trying to do is:
- using [VIC WORKED Undertime cycle hours] I'd like to compare the last two fortnight end date periods
- in the viz I'll just have a symbol (arrow up or Arrow down)
- if the latest fortnight end date has a sum([VIC WORKED Undertime cycle hours]) > than the previous period then "up" else "down"
Hope this helps a bit,
Many thanks for the great support.
undertime 160308_rep_9.0.twbx 875.4 KB