We are trying to add same KPIs but with different filters on same column chart (side by side), but not able to do.
For e.g. we want to show number of emergency breakdowns for two plants, this will require to calculate same KPI but using a filter.
Another example is to calculate downtime for two different type of work orders ( Emergency and Preventive maintenance). We want to show comparison in same chart with two columns.
Hi @anoop.singh.rajpu , for what I understand you could create a CASE WHEN specifying which plant you're referring to.
e.g.:
CASE WHEN condition THEN 'Plant A' WHEN condition THEN 'Plant B' ELSE NULL END (In the dimension field)
In the condition specify how you recognise in the table plant A and B. At this point add the KPI, you should see how it differs per plant.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
