Forum Discussion
Calculating Weekly Hours per category
Hi All,
I am looking for some help with a request ive been given.
There are a few things we are trying to do. The image atatched is a snapshot of the data i am working with:
- Create a measure that sums the total hours utilised per week, per vehicle.
- I then want to plot that in a historgram chart. The X axis would read 168 hours (total number of hours in a week). The values would be the weekly utilised hours per vehicle.
Any help would be much appreciated.
Hi,
the measure may be (see figure):
Regards FrankAT
4 Replies
Hi,
the measure may be (see figure):
Regards FrankAT
Hi Anonymous ,
If the two tables have the correct relationship, there is no difference.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Is this problem solved?
If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If not, please let me know.
Best Regards,
Icey
