Forum Discussion

Priyanka's avatar
Priyanka
Data Storage
12-08-2022

Next quarter instead of Past Quarter on widget level

Hi, I'm looking to replace the 'Past Quarter' function on the widget level with the 'Next Quarter'.  I see that there is no in-built function as such for that, ca someone help me how I get that ...
dashboards & reporting
Angelina_QBeeQ's avatar
Angelina_QBeeQ
ETL
12-08-2022

Hi Priyanka ,

Maybe the "Next" function will help you.
This function works will all time resolutions.
But it can only work as part of a measured value, not by itself.
For example, I have "Next Q Revenue" formula:

(sum([Revenue]),Next([Quarters in OrderDate],1))

And it's result :

Kind regards,
Angelina from QBeeQ 

[email protected]