Data Disappear

[Sunflower_00]

Hi All,

I created a start time and end time in the load editor script. 

I did a set analysis in the front end  to extract the hours generated. However, the hours generated field returns zeros until I select one ID and then it returns the hours. 

What could be causing the hours generated filled to behave like this? 

[Or]

This question is way too general to guess at the answer. I'd suggest posting the actual script and expression(s) used.

[cristianj23a]

Hi, More detail is required to be able to help you.

[Sunflower_00]

Hi All 

Thank you for your responses. Let me try to provide more detail.

Load

starttime

starttime+ 30 as endtime

#hour

FROM---

In the front end I did this set analysis to extract the hours between starttime and endtime:

sum({$<timestamp={"=timestamp"<= endtime"}>}  #hours) 

It works but it returns null, I have to select an ID to get the  # hours.

[menta]

i think you need to aggregate data in set analysis

sum({$<timestamp={"=$(=Max(timestamp)) <= $(=Max(endtime))"}>}  #hours)

[cristianj23a]

Hi, try this code:

sum({$<timestamp={">=$(starttime) <= $(endtime)"}>} #hours)

[Sunflower_00]

@menta  and @cristianj23a , thank you for your response. 

@menta, I tried your solution but  it doesn't change anything.

@cristianj23a , I also tried your solution and it returns the same number of hours as the #hours