cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mburrage
New Member

Data Summarisation with Box and Whisker Plots

Hi,

 

I have accessed the london fire brigade London Fire Brigade Incident Records - London Datastore to do a little work and am struggling with a simple box and whisker plot. I am using the AppSource Box and Whisker from Pieter Posthuma. 

 

The fields I am using are 

category - FRS (text field with only two different values)

sampling - incidentnumber (unique id)

value - Firstpumparriving_ attendancetime (decimal number - this is actually the number of seconds it took for the pump to arrive at the incident but is a number column in the data as I can see no way of handling duration in PowerBI - thats for another day though!)

 

The problem is that value automatically summarises so i get a box plot of the sum. 

The column properties are set to 'don't summarise' 

 

mburrage_0-1632668323835.png


Thanks

 

Mark

 

1 ACCEPTED SOLUTION
mburrage
New Member

Hi, I seem to have stumbled into my own solution. 

 

As I understand this now the value is summarised according to the sample so if, as I did have multiple records without incident numbers you have a problem as it sums all of those without a number. I rectified this by creating an index from the values and using that index as the sample. This works great but only up to 30,000 records which is something like 770,000 records short of what I need. 


All in all not a great experience and thank you to anyone who was trying to resolve.

 

Mark

View solution in original post

1 REPLY 1
mburrage
New Member

Hi, I seem to have stumbled into my own solution. 

 

As I understand this now the value is summarised according to the sample so if, as I did have multiple records without incident numbers you have a problem as it sums all of those without a number. I rectified this by creating an index from the values and using that index as the sample. This works great but only up to 30,000 records which is something like 770,000 records short of what I need. 


All in all not a great experience and thank you to anyone who was trying to resolve.

 

Mark

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!