condition

[master_student]

Hello

I need to set a condition in my expression to display the time only if it is >13:00:00 and <14:00:00

If(time(DATE_DEB)>'13:00:00', and time(DATE_DEB)>'13:00:00', '')

DATE_DEB has this format : 12/01/2016 12:32:55

any idea please

[marcus_sommer]

To display time as dimension within the chart didn't meant that you couldn't create hour/minute and so on and maybe some flags within the script and to use these fields within the chart-expressions.

- Marcus

[miguelbraga]

If so make this change:

Table:

LOAD *,

               Flag_Greater13 * Flag_Lesser14 as Flag;

LOAD *,

               if(

                    time( timestamp(DATE_DEB,'DD/MM/YYYY hh:mm:ss') )

                    >

                   time( timestamp(date(floor(DATE_DEB) ,'DD/MM/YYYY') + time(MakeTime(13),'hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'),

               1, 0) ) as Flag_Greater13,

               if(

                    time( timestamp(DATE_DEB,'DD/MM/YYYY hh:mm:ss') )

                   <

                    time( timestamp(date(floor(DATE_DEB) ,'DD/MM/YYYY') + time(MakeTime(14),'hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'),

                1, 0) ) as Flag_Lesser14;

LOAD *

FROM [your connection to your database goes here];