Next quarter instead of Past Quarter on widget level

[Priyanka]

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 function on the widget?

[Angelina_QBeeQ]

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]