Can anyone help on solving up a range visvalization in quicksight

My use case setting up the range in which the customer is currently, since the user has multiple records of reading time. The records fit in multiple range.

How to write a calculated filed to get the distinct customer with their today sum of reading hours
range of time customers
0-5 = 1 customer
6-10 = 1 customer
11-15 = 1 customer

Hi @akash22 ,

in case you only have the customer you dont need a calculated field for the sum.

For the “0 to 5” you need a calculated field. ifelse(Minutes<6,"0 to 5", ifelse(Minutes>5 AND Minutes<11,"6 to 10","11 to 15"))


1 Like