Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to put a chart showing only orders after 12pm.
Appreciate your help.
Create the Flag in script like below
if( frac([Time Measure]) > maketime(12,0,0),1,0) as TimeFlag
Now use this Flag in your Expression , one eg. is below
=Sum({<TimeFlag={'1'}>}Values)
Make sure that your [Time Measure] is correctly formatted meaning that not a string value, if it is string then try below
=if(frac(time#([Time Measure],'hh:mm:ss TT')) > maketime(12,0,0),1,0) as TimeFlag
Create the Flag in script like below
if( frac([Time Measure]) > maketime(12,0,0),1,0) as TimeFlag
Now use this Flag in your Expression , one eg. is below
=Sum({<TimeFlag={'1'}>}Values)
Make sure that your [Time Measure] is correctly formatted meaning that not a string value, if it is string then try below
=if(frac(time#([Time Measure],'hh:mm:ss TT')) > maketime(12,0,0),1,0) as TimeFlag