I want to create a visual which shows me how my measure values are distributed (sort of like a histogram)
Use-case: I having different stores and for each store I’m calculating %compliance through a calculated field on runtime. Since number of stores are very large, it makes sense that I group them in some buckets instead of showing them individually. For example I’m thinking of creating 4 buckets i.e. <40%, 40-70%, 71-94% and 95-100% and show the store count corresponding to each bucket based on compliance measure output.
I can’t do this thing in dataset i.e. assign bucket to each store in dataset (pre-calculated), as the %compliance will change based on number of days user has decided to filter the data on, and other filter selections at run time.
Can you please suggest how can i go about implementing the same in QuickSight?
Does your filters in this use-case will update both numerator and denominator values for % calculation ? . can you share some sample dataset and output how you would like to visualize ?
There are like 18 different processes. I’m calculating compliance percentage as
sum(compliance_flag)/count(compliance_flag) for each storeID and Day.
So for 7/12, compliance scores become
Store 1 66%
Store 2 100%
Store 3 33%
Now since there is huge list of stores, I wanted a visualization like a bar chart which has some sort of buckets on x-axis, stores < 40% compliance, 40-71% , 71-94% and 95%+ and on Y-axis I show the count for each bucket. The user can select the date range for a single day or multiple days. In case of multiple days, I’m simply doing sum of compliance / count of compliance for that time period (not pre-aggregating at day level)