show current month over historical data

jctorres — Tue, 25 Mar 2025 23:12:02 GMT

Good afternoon, dear friends.

I'm looking for a way to implement the pre-invoices that will be charged in 2025 in my Dashboard, but show them as of the current date in my charts. For example, it's March 2024. So, in my charts, I can filter the measurements in the analysis set to the current month. However, I created a variable that contains this: Date(Addmonths(today(SCHEDULE_DATE),+1),'MM-YYYY')

Measure: sum({$<[MONTH_YEAR_NUM] = {'$(vCurrentDate)'},[Month_Year_Name]=,Month=>}TOTAL_AMOUNT)

The problem is that when I filter by any month other than the current one, it doesn't allow me to view the measurements in my charts.

Can someone tell me if this is possible or what function to add to my variable?

I attach an example of how I have the history of my information.

Re: show current month over historical data

Bhushan_Mahajan — Thu, 27 Mar 2025 05:47:03 GMT

@jctorres Create your vCurrentDate variable based on ma scheduled date rather than today so if you select any date automatically t will work for that date as a max date.

topic show current month over historical data in App Development

show current month over historical data

Re: show current month over historical data