I am having an issue with summing minutes using intervalmatch. I am currently loading the following.
scheduleEvents: LOAD id, starttime, stoptime, ActivityTypeName from events;
intervalTable: LOAD minute, timeRangeName from MinuteSheet.xlsx;
LEFT JOIN (intervalTable) INTERVALMATCH (minute) LOAD starttime, stoptime RESIDENT scheduleEvents; LEFT JOIN (intervalTable) LOAD * RESIDENT scheduleEvents; DROP TABLE scheduleEvents;
Once loaded I am able to group by timeRangeName and count the the minutes field to get total time for the interval. The issue that I am having is the amount of resources its using and the shear size of the application. I had to scale my load down to a week worth of data at one time for 100 employee events.
I really want to increase about of days I am loading but I am scared that my terminal would explode if I did so. Is there anything that anyone recommends that might help me out with my issue.
