Hide trend line for future dates

Avatar

Avatar

lalitc72210912

Avatar

lalitc72210912

lalitc72210912

26-01-2021

Hello Community, in a trend view where in we compare stats from previous year with current year a window of 12 months is compared against each other. With respect to trend shown for future dates the line stays at the bottom of chart and is visible which is bit annoying for client. Client has requested if the trend line can end until todays date and rest be blank, as from business perspective the line falls to zero for future dates and thats not acceptable. Is there any configuration that allows us to hide the line beyond today/yesterday? Client is aware that data for future dates is not captured hence its bottomed but they have an opinion if there is no data nothing should be shown why zero?

reporting trendview

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jacob_T1

Avatar

Jacob_T1

Jacob_T1

26-01-2021

Hi @lalitc72210912 

You can achieve this result by changing your metric settings to "Interpret zeros as no value", which will hide the line visualization if you want to have a date range that goes into the future.

However, some things to consider:

  • Data for current day will change each time a user views the workspace, you could fix this with either a segment or calculated metric if this wasn't acceptable (i.e. exclude current day).
  • If any data points in the historical data were zero, this would also mean the line visualization would not display (e.g. same as dates in the future).

 

Example

Jacob_T1_0-1611708265466.png

Jacob_T1_3-1611708540642.png

Jacob_T1_2-1611708279650.png

Answers (0)