Forum Discussion
Create Measure / Column with IF using schedule.
Anonymous
This could help you in case of calculated column?
CalcShift_ = /* Shift 1 6:00:00 - 13:59:59*/ /* Shift 2 14:00:00 - 21:59:59*/ /* Shift 3 22:00:00 - 05:59:59*/ IF ( HOUR ( [CurrentTIme] ) >= 6 && HOUR ( [CurrentTIme] ) <= 13; 1; IF ( HOUR ( [CurrentTIme] ) >= 14 && HOUR ( [CurrentTIme] ) <= 21; 2; IF ( HOUR ( [CurrentTIme] ) >= 22 && HOUR ( [CurrentTIme] ) <= 23; 3; IF ( HOUR ( [CurrentTIme] ) >= 0 && HOUR ( [CurrentTIme] ) <= 5; 3; 0 ) ) ))
Anonymous
I think I did not catch the point.
I did not passed you a measure but a calculated column and eachr row contains it own value.
Do you mean how to use that value to display which equipment has been required/given back in a specific shift?
I have the following graphic:
As I went up it makes this calculation of losses.
And as you can see the hours presented are 3 shifts, but it is necessary to display information only from one shift that is the current shift.
I need now to present in this chart only the losses of my current shift and that is where the calculated column that you passed me enters.
How can I apply the calculated column that you passed me within my measurement that calculates the amount of losses?
Anonymous
X-axis should linked to shift 1/2/3 not to CurrentTime.
Then you can add a visual that allow you to filter by shift