I want to create a visual showing percentage of how many top customers sorted descending by their amount (below 80%) divided by total customers.
My data looks like this and in spreadsheet i simply make a table below to calculate:
So i know only 3 of 7 (42,9%) customers below 80%.
Is that possible using only using visual like gauge or KPI showing 42,9%, or is it only possible using Table and how to do it in quicksight?
This article should help you with parts of your questions. Look under “Categorize customers based on lifetime spend”
Yes i could do table calculation using LAA, but i can’t use the result in KPI or gauge visual.
I’ll mark as a feature request. Thanks