We would like a KPI visual that shows the percentage change over the current year, combined with the trend month by month.
With the standard KPI visual, you always see the latest change% when you add a trend ...So when you show the trend by month in the current KPI Visual, the kpi value shown is the change over the current month. We would like to see the overall YTD change% (from 1/1 until today) as KPI value and in the trend the monthly change% (so for each month the change from the first day until the last day of that month)
remark : a YTD calculation will not work because we have daily data that can not be added up (for ex daily inventory levels)
I suppose we will need the KPI value independant from the datetime-category used in the trend
Any idea if this already exists ?