cancel
Showing results for 
Search instead for 
Did you mean: 

Next quarter instead of Past Quarter on widget level

Priyanka
7 - Data Storage
7 - Data Storage

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?

1 REPLY 1

Angelina
9 - Travel Pro
9 - Travel Pro

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 :

Angelina_0-1670535155753.png

Kind regards,
Angelina from QBeeQ 

angelina.bulgakova@qbeeq.pl