Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This question is way too general to guess at the answer. I'd suggest posting the actual script and expression(s) used.
Hi, More detail is required to be able to help you.
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.
i think you need to aggregate data in set analysis
sum({$<timestamp={"=$(=Max(timestamp)) <= $(=Max(endtime))"}>} #hours)
Hi, try this code:
sum({$<timestamp={">=$(starttime) <= $(endtime)"}>} #hours)
@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