set analysis expression

[#1]

Hi,

Can someone help me to understand the next expression?

sum({$<

  METRIC_TYPE={'TtO' }

  , CREATIONTIME={">= $(= vFromDate ) < $(= vToDate +1)"}

  >} $(TIME_FACTOR) )

Thanks,

Boris

[israrkhan]

Hi,

vFromDate = taking input from user are have assigned a default value

vToDate, same like above, but adding +1 day

This Expression is doing Sum of Time_Factor, that is a field in Data Source.

But Only those Time Factor, Where Metric_Type = "Tto" and Creation_Time is Greater Than or equal to vFromDate and

Creation_Time Less Than vToDate plus one day,

for example vToDate contain a date like  20/11/2013, then vToDate + 1 will be 21/11/2013.

Hope will help,

sorry if i could not explain well

[Anonymous]

IsrarKhan,

Looks correct except of the $(TIME_FACTOR).  From the expression syntax it is rather a variable than a field.  That is, the expression returns sum of the field specified in this variable, with the conditions as you've described.

Regards,

Michael

[israrkhan]

Hi Michael,

OOOPS , did not realized that its a variable.

Thanks for corrections.

[#5]

It is indeed a field that is assigned into this variable.

does it mean that the sum is for all the values in this field even if it is assigned to a variable?

Thanks,

[Yousef_Amarneh]

I think yes

[israrkhan · Accepted solution]

no , not sum for all value,but for those value, who fall in the below criteria,

Where Metric_Type = "Tto" and Creation_Time is Greater Than or equal to vFromDate and

Creation_Time Less Than vToDate plus one day.