Set Analysis Help

[abhaysingh]

Hey guys,

i have one exp with the one field i.e.

CurrentTime_Date

i want to define a fromDate and ToDate in My Expression..i cant use Aggregation function since value contain Date and Time..

How can i define it in set Analysis..

{<FromDate = >FromDate and ToDate=    < ToDate>} CurrentTime_Date

Please Suggest

Abhay

[Anonymous]

For your drilling & Trend you need to take Avg(Temp) & slight change which I have done.

PFA..and to represent better Hour value you can use Class Function in the drilling for SHour which would give you output like..

0-1, 1-2, 2-3, 3-4 instead of 0,1,2,3,4....

[Anonymous]

You can use this expression in drilling for SHour....

=SubField(Class(SHour,1),'<',1)&'-'&SubField(Class(SHour,1),'<',3)

Which would give you result like....10-11,11-12,12-13 etc

[Anonymous]

Replace Avg(Temp) with Min(Temp)......

Its working..

[abhaysingh]

How to Do sorting in it??

0-1, 1-2, 2-3,3,3-4 and so on

[abhaysingh]

Sorting Done In QlikSense