Hello,
for instance I have a timestamp field and a revenue field. In the company are two shifts of salesperson. From 8am until 2pm and shift two operates from 2pm until 8pm. Now I have a raw table of the complete data. How to filter that with set expression. Maybe in form of two kpi windows. And these kpi windows reacts to my currenct selectin of time range in the table.
I thought of something like this for the first shift:
sum({<shifttime={">=$(=Timestamp(shifttime))<=timestamp(shifttime))"}>}revenue)
I just don't know where to put the two times of every shift in the formula. The second part of the timestamp()- function 'DD/MM/YYYY hh:mm:ss' is for the formatting and not for the timerange itself. Also I want the data of the current selection and not just this month or last year.
I hope someone has an idea.
Thank you very much in advance.
Best.
