Hi, I'm hoping someone would be able to help me please. I have a K Means cluster chart on my app and I have it coloured by this expression:
=aggr(KMeans2D(0,[TY Wastage Cost (£)],[TY Reduced Cost (£)], 'zscore')+1, [Area Manager])
The clusters show the Area Manager and when you click into the Area Manager, the Retailer Names of their stores show. However, the colours aren't showing when I click into the Retailer Names. I have tried amending the formula to the below but that doesn't work either:
=aggr(KMeans2D(0,[TY Wastage Cost (£)],[TY Reduced Cost (£)], 'zscore')+1, [Area Manager], [Retailer Name])
Any advice please as to what I'm doing wrong?
Thanks!