Forum Discussion

Pizamka0's avatar
Pizamka0
Frequent Visitor
2 years ago

Differences in quartile values when using card visual and percentile line on the bar chart

Hi everyone,

Below I have some anonymised data. I have calculated quartiles for specific service metric using the PERCENTILE.INC

I have also checked the same calculation in Excel and R using the respective functions. All give me the same result for Q3, which is 2,585.75

Could someone tell me why the quartiles displayed on the bar chart are different to the calculated ones?

Thank you in advance!

 

General Comment

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Pizamka0 seems like you are visualizing the data by service type and not by quarters. For each bar, the data is getting filtered for the service type value on the x-axis.

    • Pizamka0's avatar
      Pizamka0
      Frequent Visitor
      2 years ago

      Thank you. Sorry, should have been clearer when positng the original questions. For this type of chart I don't find it particulairly useful when quartiles are filtered by service. Is there a way of just including the quartiles for all services apart from adding a custom line with the specific quartile measure? Thank you