Box & Whisker Plot - Using a summarised value
Hi,
I'd like to create a Box & Whisker Plot to show the distribution of "Bookings" by "Day of Week" across the time period so the client/tenant should be able to see, for example, that on Mondays their bookings can range from 150 to 325 but there are a couple of outliers. Currently, my model uses a count of unique Booking ID's to figure out the number of bookings from a fact table in the Elasticube.
The issue is that adding Booking IDs to the widget only allows me to select "all values" and so instead of being able to count the total number per day of week, it's adding up each individual Booking ID since Booking ID's are an integer.
How can I get around this to count the bookings per day of week? I'm sure I'm missing something but it seems like there should be a simpler way to do this.
Thanks in advance.
Hi Shams,
Thank you for replying. I have reached out to your account team to get a technical resource assigned.