Box & Whisker Plot - Using a summarised value

[Shams]

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.

[Shams]

UPDATE: 

I've created a new summary table in the elasticube to get around this which summarises the total bookings for each day. The table can only really be connected to my Dim_Date table since it's at a date granularity now. The issue with doing it this way is we lose the ability of any filters on each booking affecting the widget.

It's a shame the default behaviour of the widget doesn't allow us to perform a summary on a field for the categories. Please can this be fixed? 

[DRay]

Hi @Shams,

I would like to connect you with a technical resource that will work on this use case with you. Would you like me to get the ball rolling on that?

[Shams]

Hi David, that would be a big help! I was also trying to order the categories on the box & whisker plot by month. I tried bringing in the field using the month numbers and then changing the script to match what I'd done on bar charts before to reformat the month number into the relevant month but it never worked. When I printed ev.result, I could see xAxis.categories and series but I kept getting errors in the console saying they didn't exist. 

[DRay · Accepted solution]

Hi @Shams,

Thank you for replying. I have reached out to your account team to get a technical resource assigned.