Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
I'm trying to group weekly data in a graph chart, basically it's number of processes initiated by users in a given week. I have created a master calendar where I get the week number (for 2015 until today), and I want to see per week, the number of processes started on that week, and also the number of processes finished on that same week, side by side. The problem I run into is that I get the mere count of processes on a certain week based on my selection, instead of all the processes that were finished in the same week as my selection. So for below example:
Process ID StartWeek EndWeek
20084662 15 16
10254531 15 15
10254532 15 15
20132295 15 17
20132294 15 16
20134879 14 15
20136216 14 14
20018337 13 15
10254538 15 16
10254540 12 13
10254541 14 14
For week 15, I would like to get the number 4 (Number of processes that were finished in week 15), but I keep getting 6 (count of end weeks that started in week 15). I've tried a few different things but nothing worked. Any ideas? Thanks in advance!
Panos
Hi,
use EndWeek as your dimension and count({Process ID]) as your expression.
See Attached
Andy
See attached example.
Hi both, thanks for your help, I could only find the time to test them just now. Gysbert's answer with a few changes was what I was looking for, thanks!