Sparkline - specific time selection ?
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 ?
thank you for your help,
Hi @aeyzat ,
You can achieve this by applying filter on time:
Example: sparkline without any time filter
Example sparkline with time filter (showing only 1st quarter)
> 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)
I'm facing similar issue but at monthly level. I want to sparkline for only my actual months in planning fiscal year. In my case Jan 22 to May 22 data
I've applied filter on time period and context selector is showing only those 5 months but sparkline is still showing entire 12 Months. Jan 22 to Dec 22