I want to get the value in yellow in the bullet chart. I put $(kpi_Sales_Turnover_Qty) in the visualisation but i have the total of the kpi and not the number for each plant.
How can i get the number for each plant ?
Not a hundred percent sure you can achieve that, but you could use a custom tool tip to show on hover over?
Maybe you can try this with the Aggr function.
Something like this: "aggr(sum(sales),Plant)"