Forum Discussion
Visualisation Advice
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
4 Replies
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] * 6I 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!
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!
Hi Anonymous ,
You could add a rule in filter pane to make result show value which is not blank.
