Forum Discussion
Solved
Auto change once shift changes
Hi Experties, I wouldlike to set auto change option once 1st shift completed it should start showing 2nd shift data. Ex : 1st shift is 6AM to 12 PM 2nd shift is 12 PM to 6PM. When th...
hi SSBkrish
did you have a column in your data which includes values "1st shift / 2nd shift" ?? if so, then you can write a measure as follows:
Measure= var shift_definition =if(HOUR(NOW()) >=6 && HOUR(NOW()) <12 , "1st shift" , if(HOUR(NOW()) >=12 && HOUR(NOW()) <18 , "2nd shift",0))returnif (selectedvalue(your_table [shift]) = shift_definition , 1,0)and then add this to your visual filter pane and set it to 1 as follows:if it doesn't work please provide more details of your table data.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
I am getting beloow error
did you define a name for your measure before defining "var"? I mean...
measure := var shift_definition......