Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago

Filter By Year Dynamically

Hi,

 

I ran into a dead end that I like my graph display the Year from Current Year and to the following 5 consecutive year (2018-2022) dynamically without having me filter or slice it manully each time.

 

Here is the function I wrote. Then I dropped it into tooltips and filtered it by 1.

Column = IF([Year] >= YEAR(NOW()),"Future Year","")

Can someone help me?

Need Help
Show and Tell
Tutorial Requests

8 Replies

  • marcoslopez's avatar
    marcoslopez
    Helper I
    7 years ago

    Hi Stuznet, you could create a calculated column that shows 0 if year(date) < year(today) and the value with future dates.

    Hope this help you, apologies for my bad english :smileyhappy:

    Best Regards, Marcos

    • Stuznet's avatar
      Stuznet
      Helper V
      7 years ago

      marcoslopezthank you for your input. I tried your suggested function.

      Column = IF(YEAR([Date]) < YEAR(TODAY()),1,0)

      I'm getting the same result as it shown on the chart from above. 

      • marcoslopez's avatar
        marcoslopez
        Helper I
        7 years ago

        That I said was sth like having Column Total Invoices then 
        New Calculated Column:
        Total Estimated Invoices =
            if (
                 year(InvoiceDate) >= year( today() );
                 Total Invoices;
                 0
                )