Forum Discussion

shyamji's avatar
shyamji
Helper I
6 years ago

Get All Months Even No Data

Hi,

i am trying to display a chart for last 12 months, if i use year/month on x-axis but months having no data are not shown on chart.

Please help to display all months on chart.

Thanks

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Sometimes this works:

     

    Measure = 

      VAR __Calc = <some calculation>

    RETURN

      IF(ISBLANK(__Calc),0,__Calc_)