class function and clock

[#1]

Hi everyone,

I'm trying to do this :

=class(HRE_SORTIE, timestamp('0.0833','hh:mm'), 'Heures')

thing is, in the graphic chart , it's shown like that : 0.08333<Heures<0.0.....

The HRE_SORTIE field store clock data like this : 14:00,12:55......(thanks to timestamp) and even if I put class(HRE_SORTIE, '2:00' , 'Heures') as a dimension in the chart, it's still shown like this : 0.08333333<Heures<0.0..... in the graphic chart.

How can I do to display '0:00<Heures<2:00' in this chart?

Thx ,

Will

[#2]

Hi Will, you can use a calculated dimmension similiar to the following:

=time(subfield(class(TH, '2:00' , 'Heures'),'<=',1),'HH:MM:SS') & ' <= Heures < '& time(subfield(class(TH, '2:00' , 'Heures'),'<',3),'HH:MM:SS')

See attached example.

Regards

[#3]

Hi,

Your trick finally work. thanks.