Hi,
I have a dataset with some duplicated data and I want to create a box plot but without the duplicates.
so the dataset is like this
and I want to keep event id 4 just one time because it distorts my box plot. The same happens with other event ids also.
I tried with the below calculated field but then the box plot does not work. How to create it with the correct numbers?
avg({metric}, [{Event ID}])
Hi @pantelis,
Could you provide us with some additional context on how this is being visualized in the box plot? How are you grouping the data points?
Box plots expect raw values since they distribute the data points out based on the grouping; if you try to run the average of your value, that narrows down to one row and therefore makes a box plot somewhat useless.
Is there another field in your dataset where these rows split which is causing the duplicate rows to exist?
If so, you could try creating a denserank function with that as a dimension, then use that as a filter to only include rank 1.
Hi @pantelis
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @pantelis
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!