Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is it possible to have in the same X-Axis the average from last 4 years and the average from current year each month? Bellow a picture showing what I would like to create:
Thank you!
one possible solution using a calculated dimension:
=Aggr(If(Year(MonthYear)<Year(Today()),Year(MonthYear),MonthYear),MonthYear)
for reference, using this data:
one possible solution using a calculated dimension:
=Aggr(If(Year(MonthYear)<Year(Today()),Year(MonthYear),MonthYear),MonthYear)
for reference, using this data:
Hi Marco
This answer is so close from what I need, If I may ask two more questions:
1) Is it possible for currently year show all month even I don't have the numbers yet? Something close to picture bellow
2) I have uploaded two dummy values with 2023 date just for test, but it is showing as number not date. I don't know if makes any difference but my database is formated date like dd/mm/yyyy.