Forum Discussion

shyamji's avatar
shyamji
Icon for Helper I rankHelper 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
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

Sometimes this works:

 

Measure = 

  VAR __Calc = <some calculation>

RETURN

  IF(ISBLANK(__Calc),0,__Calc_)