Greetings,
(Contextualization)
Here, where I work, I had the challenge of putting together a program that associates events with a schedule table.
(For example, within an employee's working hours, which events are associated with it based only on the time and place it occurred).
I managed to make the association satisfactorily with the IntervalMatch() function,
Now the next step is to perform an accumulation of values for each file with the operator in question, that is:
(Doubt)
I have two tables, one consists of location, operator and time interval, in the second table I have an event with location, time and associated values. How could I perform an accumulated sum of the operations performed by the operator in his hours?
(Attempts)
For this, I've already heard the recommendation to do the calculation in the script, using the Previous() function, I can even compare the fields and add the values, but as the Operator is only connected by a synthetic key, which is calculated after running the script I can't use Operator as a criterion, I don't know if I'm on the right path, another suggestion I've already followed was the use of Set Analysis, but for each line, there will be a different operator value to be compared (try to follow something like comparing an interval with a field next to it, but in Excel) anyway, I don't understand...
Eventually I would need to compare the performance of the same cashier / shift over time, leaving everything depending on the table order doesn't seem to be the best case, I couldn't generate a .QVD but I made an example of the data in a text block that I will provide in brief (from the script),
Thanks in advance for any support.
