How to make a conditional chart

[#1]

I have a table with a field called T0, in this format DD, hh:mm:ss, the idea is to make a table that only count the values major to 00, 00:30:00, I used the expression :

Count(if(T0 >= 00, 00:30:00, T0))

but the expression editor shows an error.

How can I do that ?

[its_anandrjs]

Hi,

Do you have any sample of this it will be more easy.

Regards,

Anand

[ToniKautto]

You need to quote strings, otherwise you will get an error. I am not convinced that your expression will work, depending on what data type T0 has. So if it does not work, please attach a QVW sample to enable more detailed advice.

The expression needs quoting;

Count(if(T0 >= '00, 00:30:00', T0))

[its_anandrjs]

Hi,

Yes you need to write a check code it single quotes like Count(if(T0 >= '00, 00:30:00', T0)) like Toni suggested it is also depents on your data type of 00, 00:30:00 field it is then you need to check, if you have any sample will be easy.

Regards,

Anand