Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to make Line Chart stop mid-graph for future weeks

Hi,   I've made a line chart, showcasing the accumultion of received applications throughout the weeks of 2022 compared to 2021.    The dataline for 2022, do not have values/data for future weeks...
  • littlemojopuppy's avatar
    littlemojopuppy
    4 years ago

    Hi Anonymous 

     

    What you want to do is compare the current (or possibly last) week number available in the data to the week number in the axis - use MAX(WeekNumber).  If the week number in the axis > current/last available in data then BLANK() otherwise show value.

     

    Hope this helps!

littlemojopuppy's avatar
littlemojopuppy
Community Champion
4 years ago

Hi Anonymous 

 

What you want to do is compare the current (or possibly last) week number available in the data to the week number in the axis - use MAX(WeekNumber).  If the week number in the axis > current/last available in data then BLANK() otherwise show value.

 

Hope this helps!