Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Create Measure / Column with IF using schedule.

I need to create a measure or field in which depending on the current schedule of my system it shows in which shift we are, for example:   Today we have the 24 hours divided into 3 shifts: Turn A ...
Need Help
  • gpiero's avatar
    gpiero
    9 years ago

    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 )
    )
))

     

gpiero's avatar
gpiero
Skilled Sharer
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

gpiero

 

Yes in modeling the data is already related but I can not apply the rule that I need in a filter in the graph, but in the measure that I have passed.

How could I apply the calculated column that you passed me as far as I could?

  • gpiero's avatar
    gpiero
    Skilled Sharer
    9 years ago

    Do you mean like this?

     

     

     

    test

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      gpiero

      Yes it is almost that, instead of showing the three shifts (1, 2, 3) I want to show only one shift, which is happening now and on the X axis would be the hours for that shift.