Forum Discussion
How to show average hours on graph
I am sure you are trying to be clear, but it is not clear to me. How about you create a chart in Excel using the data you have posted above so it is clear what you want.
Great suggestion!
I could have thought of it that way before.
Unfortuanltey you cannot use time as measure, to achieve this, convert time to number and then use it. See image below, let me know if you need help on how to do this?
Yes! I need to know how!
I tried to put it as duration but it did not work out.
That way that presented in the image is the form that I need.
This is what I did, not added duration but converted time to number. Assuming your tempo field is of datetime type.
- click Add Column
- if DataType of tempo field is datetime then add this formula for custom field -> DateTime.ToText([Tempo], "HH.mm")
- if DataType of tempo field is Time then add this formula for customer field -> Time.ToText([Tempo], "HH.mm")
- Change this new custom field to fdecimal number
Now add this new custom field in your bar graph as value.
Also make sure in above formula, there is dot (.) between HH and mm. Try it.
If you need further help, I can send you pbix file, send me a private message with your email in it.
Thanks,
