Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My end user has the opportunity to choose months in year for comparison to months from previous year. I have two calendars in the dashboard and the user has to pick those dates from both. I would like to make this picking more easy – if the end user picks the dates from 2019, the same dates from 2018 would be picked automatically. What is tricky – months don’t have to be continuous, for example he can pick only September and May.
Does anyone have an idea how to solve this?
This is for Multiple Selections,
Months:
=Concat(Distinct MonthName(addmonths(MonthName,-12)),',') // Previous year months
=Concat(Distinct Monthname(MonthName),',') //Current Year Months
Date:
=Concat(Distinct Date(AddYears(ShipDate,-1)),',') // Previous year dates
=Concat(Distinct Date(ShipDate),',') //Current Year Dates
You can use the same in Set analysis for comparison reports.
PFA for ref. Let me know if i missed any.
With your Date Fields in UI,
Dates:
Date(AddYears(Max(Date),-1)) // Previous Year Same Date
Date(Max(Date)) //Current Date
Months:
monthName(addmonths(Max(MonthName),-12)) // Previous Year Same Month
Monthname(Max(MonthName)) //Current Date
This is for Multiple Selections,
Months:
=Concat(Distinct MonthName(addmonths(MonthName,-12)),',') // Previous year months
=Concat(Distinct Monthname(MonthName),',') //Current Year Months
Date:
=Concat(Distinct Date(AddYears(ShipDate,-1)),',') // Previous year dates
=Concat(Distinct Date(ShipDate),',') //Current Year Dates
You can use the same in Set analysis for comparison reports.
PFA for ref. Let me know if i missed any.
Thank you very much 🙂