Hi guys, really need your help.
I have a simple table with shops their stock and their sales. On that Table a added a measure based and stock and sales to give me a KPI named Availability. This KPI measures the faults of stock on the stores. Everything is fine.
What I need help with is that now, I want to cluster the shops based on this measure I created. The Availability is a percentage measure so every shop has its number. The reason a created as a measure is because the calculation may vary upon filters.
My first thought was to create another measure that read it from the availability. Something simple as Target := (IF [Availability]>=0,90 then "In Target"; "Off Target"). And it works.
My problem is: I want to make a Donnut on the Target variable, counting the number of Shop In Target and the ones Off Target.
My first idea was to put the Target Measure as value on the Donnut Chart. It won't work. It just let me add it as a tooltip.
What am I doing wrong?
