Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 shou...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hey

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

    Then it all worked!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hey

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

    Then it all worked!