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

dashboards & reporting

1 Reply

Replies have been turned off for this discussion
  • 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]