I need to dynamically show the previous month data in the dashboard without using any filter option for the user to select
I have 3 field as string for Financial montha nd year where using this i need to select the previous month and year based on financial period (April-March)
I need to dynamically show the previous month data in the dashboard without using any filter option for the user to select how to do that
i have finacial_month (1,2,3,-12)and finacial_year(2019-2025) as int how to achieve the above
Hi, @Preethika T
How about adding the following calculated field to the filter field and setting it to True?
This is a filter that compares the year and month as a date with the previous month calculated from today's date.
dateparse('yyyyMM',str([finacial_year]*100+[finacial_month]))=dateadd('month',-1,datetrunc('month',today()))
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
