Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Account for Gaps in Line Graph

Hi there,

 

I have a graph where there is a gap as there is no data for that particular month. This is not a lack of data quality but rather that there were no absences in that month.

Is there a way I can get the graph to connect and simply replace the missing point with a 0?

 

Thanks!

 

Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

    Hi, 

     

    If you're using a measure, have you tried adding +0 on the end? That should replace your blank values with 0, so the line should join

2 Replies

  • AntonioM's avatar
    AntonioM
    Solution Sage
    4 years ago

    Hi, 

     

    If you're using a measure, have you tried adding +0 on the end? That should replace your blank values with 0, so the line should join

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That worked thank you! Neat trick ğŸ˜Š