Avoid summarizing data of same category

[endzz]

Hi everyone,

I am trying to build a maintenance KPI sorted by failure cause and showing the duration of each occurrence.

My duration data on the same equipment and with the same cause are naturally added together, but the notion of occurrence does not appear. For example, the value 5.5 actually corresponds to 3 "breakdowns": 1x 3h / 1x 2h / 1x 0.5h :

Is there a way not to add these data together and get something like this :

Thank you in advance

[Anonymous · Accepted solution]

@endzz,

Do you have breakdown column? If you have the following table, you can use Infographic Designer custom visual to display the data.


Regards,
Lydia