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...
Need Help
Show and Tell
Tutorial Requests
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
        )

  • Stuznet's avatar
    Stuznet
    Helper V
    7 years ago

    marcoslopezI tried that and it giving false result.

    Column = IF(YEAR([Date]) >= YEAR(TODAY()),[Total],0)

    • PJHos's avatar
      PJHos
      Advocate I
      3 years ago
      Last 6 Years Filter = IF(AND(YEAR([Date]) >= YEAR(TODAY()) - 6,YEAR([Date}) <= YEAR(TODAY()) + 2), YEAR([Date}), 0 )
       
      this is what iwe have to create a dynamic filter that looks at previous 6 years and future 2 years. Future dates as i use it in a forecast graph. Add it as a calculated column and apply as a filter, conditions for filter = 'is not 0'