Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
name | Service | Date | Semaine | month | day | Hours Arrival |
agent 5 | INFORMATIQUE | 04/02/2014 | 6 | February | Tuesday | 07:56:08 |
agent 7 | INFORMATIQUE | 04/02/2014 | 6 | February | Tuesday | 07:52:20 |
agent 1 | INFORMATIQUE | 03/02/2014 | 6 | February | Monday | 08:37:58 |
agent 1 | INFORMATIQUE | 04/02/2014 | 6 | February | Tuesday | 08:15:14 |
agent 1 | INFORMATIQUE | 05/02/2014 | 6 | February | Wednesday | 08:38:14 |
agent 1 | INFORMATIQUE | 06/02/2014 | 6 | February | Thursday | 08:20:36 |
agent 4 | INFORMATIQUE | 03/02/2014 | 6 | February | Monday | 07:45:54 |
agent 4 | INFORMATIQUE | 07/02/2014 | 6 | February | Friday | 07:50:46 |
agent 6 | INFORMATIQUE | 05/02/2014 | 6 | February | Wednesday | 13:23:36 |
agent 6 | INFORMATIQUE | 07/02/2014 | 6 | February | Friday | 15:38:20 |
agent 2 | INFORMATIQUE | 03/02/2014 | 6 | February | Monday | 07:49:18 |
agent 2 | INFORMATIQUE | 04/02/2014 | 6 | February | Tuesday | 07:49:12 |
agent 2 | INFORMATIQUE | 05/02/2014 | 6 | February | Wednesday | 08:03:18 |
agent 2 | INFORMATIQUE | 06/02/2014 | 6 | February | Thursday | 08:08:40 |
agent 2 | INFORMATIQUE | 07/02/2014 | 6 | February | Friday | 07:58:28 |
agent 3 | INFORMATIQUE | 04/02/2014 | 6 | February | Tuesday | 08:00:26 |
Now my problem is how can we have the sum of all minimum an agent or counting to get a result like that.
agent 1 = 4
agent 2 = 5
agent 3 = 1
agent 4 = 2
agent 5 = 1
agent 6 = 2
agent 7 = 1
add a tablebox using Table and verify if the records you wants are flagged
if yes build the chart using the expression in my attachment (modified because of different source data);
dimension idusager
expression count({$ <FLAGLATE={1},FLAGMINHOURS={1}>} DISTINCT date)
thank you it works well
Please close this discussion by giving Correct and Helpful answers to the posts which are useful for you. It helps others in finding answers for similar scenarios.