I have a process where the throughput is very slow and the template visualization of throughput per hour isn't useful. I am trying to get a table or visualization for throughput per week. Specifically I am trying to count the number of flow items with various label values per unit time. So "in week 1 we had x number of item with 'label1=a' label go through, and y number of items with label2='b' label, in week 2 etc..." The end result I want is a table that has a new row for every week, with a column for the count of every label value I am interested in.
What I have tried so far: I made a statistics collector which listens to processors at different stages of the process (the ones I am interested in), and they record the labels and model.time for every flow item on exit. That works fine.
When I try to use a calculated table however, I cannot seem to find the right options to aggregate the data such that I get a count of flow items with the right labels over a one-week period. I've tried using pure SQL but FlexSim seems to have a limited number of functions available and doesn't support FLOOR or timestamp functions. I know this is possible, any ideas?