Forum Discussion
Efficency calculation
Hello,
I have data, "total time it took to create the part"(time) and "working mins" (Whole Number).
Is here a way to divide one into the other.
This data would then be used to provide a percentage for the machine efficency for the day, week, month etc.
I would really appreciate and help/ suggestions on this
Thanks in advance
Hi Anonymous
Create a measure like below.Then drag the date column and the measure to a table visual.
Measure = DIVIDE ( CALCULATE ( SUM ( Table1[Time_Second] ) ), CALCULATE ( MAX ( Table1[Working-Second] ) ) )Regards,
7 Replies
Hi Anonymous
You may convent them to seconds columns.Then use the seconds columns to get the percent as requested.
Time_second = HOUR ( [Time it took to create the part] ) * 60 * 60 + MINUTE ( [Time it took to create the part] ) * 60 + SECOND ( [Time it took to create the part] )Working_second = Table2[Working mins]*60
Regards,
Thanks v-cherch-msft for your help.
Im am now having an issue with the division
if i divide Time_Second into Working_Second in a measure it will sum all of the working mins
eg Sum of Thursday working seconds = 172 +172 +171 + 80 + 141 +415 = 1,151
but it also totals all the working seconds 32400 x 6 = 194,400
Is there a way to divide it by a single 32400
(I intend to create report visualisation by day, week month etc so cant select lowest number etc
Hi Anonymous
You may create a measure with MAX function to get it.If it is not your case,please share some sample data and expected output which would be helpful to provide an accurate solution.
Measure = DIVIDE ( MAX ( [Working_second] ), SUM ( [Time_Second] ) )
How to Get Your Question Answered Quickly
Regards,