Show data from date range of current and previous year
Lately I'm having this issue whenever someone selects an specific date or date range from this year in any of the charts from the dashboard that supposedly have to show the same data but from the previous year.
I don't know why but at the beginning it was working fine (only when I selected a year from the year filter), but but now it doesn't seems work anymore.
The field that I'm using fot the Year filter is this one: =[his_date.autoCalendar.Year]
This is the expression that I'm using to calculate the values:
Re: Show data from date range of current and previous year
Thank you very much for your prompt answer!
I tried with the recommendations that you gave me and it didn't seems to work. I don´t know why because I think that your approaching is the right one, it has to be related to data level and the expression that I'm using should be filtered at date level.
I don't know if it's important but I'm using the generated auto calendar fields to filter for year ([his_date.autoCalendar.Year]), quarter ([his_date.autoCalendar.Quarter]) and month ([his_date.autoCalendar.Month]) from the field his_date.
I have reviewed the forum and some websites and tried to use the recommendations and solutions, but I couldn't make it work. There is one the As of Table but I don't know how to apply it 😞
Please let me know if you need me to share anything more like more info.