Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Line chart with Years, and Month for only current year

I want to do a line chart, where years between 2006 and 2020 are shown, no months. But for 2020 it would also show the months.   So the date axis would look like:   2006 2007 2008.... 2019 2020 J...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    You can create a new column in your date dimension like that and use

     

    New column = If(year([Date] =year(today()), format([Date],"MMM YYYY"), format([date],"YYYY"))

seanguerrero's avatar
seanguerrero
Icon for Helper I rankHelper I
4 years ago

As always, great solution amitchandak. Any tips on sorting now? I now have 2019 2020 2021 2022Feb 2022Jan. ...or should I just create a separate sort table?