I’m new to Quicksight and please forgive me if my question sounds naive.
I have a table where each row represents a record. The first column is the ID of an item, and each item has a corresponding time with different values. I need to classify the items into three classes. For example, if an item’s corresponding time is in the past and its average value is less than 50, it belongs to the ‘RED’ class. If the average value is greater than or equal to 50, it belongs to the ‘YELLOW’ class. If the corresponding time is in the future, it belongs to the ‘GREEN’ class.
Now, I want to aggregate this table and create a pie chart that represents the number of items in each class. How should I do this? I tried using a calculated field, but it does not work for pie chart plotting.
Hi @robkc , thank you so much for your reply!
The value column needs to first aggregate then classify, and the time should always be same for the same item, so we don’t need to worry about the difference of date.