search

liprec / powerbi-boxWhiskerChart

Home of the code of my Power BI Custom Visual: Box and Whisker chart
MIT License
8 stars 4 forks source link

Average calculations #6

Closed Wford1 closed 6 years ago

Wford1 commented 7 years ago

Hi is there some information available on how this is calculated in the visual.It calculates different values than the ones calculated by another power bi visual.The average also seems to differ from the excell calculation of the data.From what I can tell is that there are two of the same values in the data list and it only uses one of them, although it is two distinct values.It may be that I am missing something obvious but I would appreciate some more information regarding this if it is possible

liprec commented 7 years ago

Sorry for the late response, but I will look into this. It should be a generic average calculation: sum(datapoints)/count(datapoints) and therefor use the duplicate values.

liprec commented 6 years ago

Sorry, I cannot reproduce this. Can you provide an example is it is still valid?

Thanks.

Wford1 commented 6 years ago

I am suspecting now that this might be unique the data set or that way the other visuals where setup. Seem to have been unique to the way I set up the other visuals. thanks for looking into it