Can anyone help on solving up a range visvalization in quicksight

[akash22]

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
Like
range of time customers
0-5 = 1 customer
6-10 = 1 customer
11-15 = 1 customer

[ErikG]

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"))

BR