Heat Map and Percent of total

Q&A
,
1

image
image1201×757 99.1 KB

I want to replicate the similar thing in Quicksight, How do I achieve it?
I need bins with values starting from 0 to 1800 and then want to show percent of total across the bins for each row .

2

@Hunny

You have to use percentOfTotal function. I have made 3 solutions to show :

  1. percentage of total across the bins for each row = percentOfTotal(sum(VALOR),[MEDIDA])
  2. percentage of total across the bins for each col = percentOfTotal(sum(VALOR),[BIN])
  3. percentage of total across the bins for general total = percentOfTotal(sum(VALOR))

image
image963×701 46.6 KB

image

Let me know if that resolves the issue!

Regards, José Miguel Burrull

1 Like
3

Hi @Hunny ,

I’m marking @jose_burrull 's response as solution here.
Please let us know if you have further questions.

Regards,
Arun Santhosh
Pr QuickSight SA

2 Likes