Visualisation Advice

[Anonymous]

Hello all,

I am not sure how to best visualise a metric and thought I may see what others suggest.

We have a metric that is a ratio. For every 1 safety Incident that occurs the organisation should be conducting 6 positive preventative actions.

So a 6:1 ratio.

We track these in a system and I can pull and manipulate the data to get the numbers, what I am not sure on how to do is represent it visually. So an example would be...

Actual - 213 Incidents : 540 Positive actions

Target - 213 Incidents : 1278 Positive actions (213 x 6)

We cannot "control" the number of incidents that occur but we can increase the expectation of positive actions. The "incident" number will grow an a day to day basis so the "213" in this situation is not fixed or predetermined.

Cheers,

J

[parry2k]

@Anonymous you can use combo chart where actuals can be on the bar and target as line chart, and measure for actuals and target will be

Actuals = COUNT ( Table[Incidents] )

Target = [Actuals] * 6

I would 💖 Kudos 🙂 if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous]

Hey thanks for that ! I like that idea.

Now that I have applied it I cannot get it to behave properly!

This is my very basic date table

This is the outcome if I apply dd/mm/yyyy date to the X axis. It is correct but I dont want it day by day.

This is the outcome if I do it by month name... but I cannot get it to go in proper month order??

This is the outcome with month number. Strangely it adds a "0" which I dont want and alternates labels??

Also as an aside I would like it to display 13 months as we often review things as 13MMA.

Thanks!

[v-eachen-msft]

Hi @Anonymous ,

You could add a rule in filter pane to make result show value which is not blank.

[Anonymous · Accepted solution]

Hey

I found out for myself. I needed to create a column to sort by "yyyy mm"

Then it all worked!