8 Replies Latest reply on Apr 27, 2016 10:56 AM by Tableaunew learning

    Graph per Fiscal Quarter

    Tableaunew learning

      I have a requirement where i want to show progress in color within a quarter (if it's arrived).if quarter is arrived and deadline hasn't met yet then it will be in Red and if quarter is not yet arrived then it should be in green. and my fiscal year starts from Feb.

       

      I have attached sample workbook here, which doesn't seem right to me.

      1) As i changed fiscal month from Jan to Feb it changes year from 2016 to 2017 (which shouldn't be)

      2) in data, only Q1 is ongoing so that should be Red rest quarters have not yet arrived, so should be in green

       

      Any help will be helpful.

       

      Thanks,