Customers percentage below 80% of total Amount

Question & Answer
, ,
1

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:

image
image977×728 49 KB

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?

2

This article should help you with parts of your questions. Look under “Categorize customers based on lifetime spend”

1 Like
3

Yes i could do table calculation using LAA, but i can’t use the result in KPI or gauge visual.
Thx.

4

I’ll mark as a feature request. Thanks

1 Like