Hide trend line for future dates

Avatar

Avatar
Validate 1
Level 1
lalitc72210912
Level 1

Like

1 like

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
lalitc72210912
Level 1

Like

1 like

Total Posts

1 post

Correct reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
lalitc72210912
Level 1

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?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 3
Level 2
Jacob_T1
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

2 solutions
Top badges earned
Boost 3
Boost 1
Applaud 5
Affirm 1
View profile

Avatar
Boost 3
Level 2
Jacob_T1
Level 2

Likes

4 likes

Total Posts

4 posts

Correct reply

2 solutions
Top badges earned
Boost 3
Boost 1
Applaud 5
Affirm 1
View profile
Jacob_T1
Level 2

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)