Forum Discussion
Question about Box and Whisker chart
I am in need of preparing dashboard with some statistical visualizations. Among others I need to show Boxplot chart.
I downloaded Box and Whisker by MAQ Software (which has ‘PBI Certified’ flag).
Trying it out I realized it gives me strange results, different that the ones I got using measures in the table / matrix.
I checked the data manually - the table numbers are correct.
Does anyone know / can explain mechanisms of this Box and Whisker by MAQ Software?
Measures in the table:
Mean = AVERAGE(Flow[TimeOnSubphase]),
Quartile 1 = PERCENTILE.inc(Flow[TimeOnSubphase],.25),
Median = MEDIAN(Flow[TimeOnSubphase]),
Quartile 3 = PERCENTILE.INC(Flow[TimeOnSubphase],.75)
I finally figured out the answer to my question. The Box and Whisker by MAQ Software has limitation of 30000 sampling rows. I guess that it just simply disregards the rest of the rows... You can observe it when using another statistical visualization called Violin plot - this one also has limitation of 30k rows, which is visible on the tooltip. In first screen you can see comparison between Violin tooltip and my data - I had raw data with 60k+ rows. When I did some filtering on my data and went below 30k the numbers on both viz and table became consistent (screen 2 and 3).
In my humble opinion there should be some information about this limitation…
1 Reply
I finally figured out the answer to my question. The Box and Whisker by MAQ Software has limitation of 30000 sampling rows. I guess that it just simply disregards the rest of the rows... You can observe it when using another statistical visualization called Violin plot - this one also has limitation of 30k rows, which is visible on the tooltip. In first screen you can see comparison between Violin tooltip and my data - I had raw data with 60k+ rows. When I did some filtering on my data and went below 30k the numbers on both viz and table became consistent (screen 2 and 3).
In my humble opinion there should be some information about this limitation…