Sparkline - specific time selection ?

aeyzat
Occasional Contributor

Sparkline - specific time selection ?

Hello, 

 

I was wondering if it's possible to choose a specific time selection for sparkline, and how to do it ? 

Indeed I have a dashboard filtered on a specific week for example here the week 23, 

The KPI growth % and the sparkline associated show me the trend of the week 22 to week 26, but i would like to have only the trend of the 5 weeks before the week 23 to see the past and not the future (week 18 to week 23).

Is that possible ? 

 

 

aeyzat_0-1623847264851.png

 

thank you for your help, 

 

amélie 

 

1 REPLY 1
vinayvm
Certified Master Anaplanner

Re: Sparkline - specific time selection ?

Hi @aeyzat ,

 

You can achieve this by applying filter on time:

 

Example: sparkline without any time filter

Screenshot 2021-06-16 at 6.48.47 PM.png

 

Example sparkline with time filter (showing only 1st quarter)

Screenshot 2021-06-16 at 6.50.40 PM.png

 

Time filter:

Screenshot 2021-06-16 at 6.50.09 PM.png

> However, this will limit your selections on the time context selector, but if you would want to show only those previous periods, then it should work

> Also, since sparklines work in alignment with time summary, you cannot plot data pertaining to partial weeks which are part of two months (in this case, weeks 18 to 23 do fall in two months)

> You might want to try a workaround such as to zero out the data of other weeks, so that the sparkline captures only non-zero values as needed (and you would not need any filtering in this case)

 

Regards,

vinayvm