2 weeks ago
Hi!
I am trying to create a story report where I want to report on number of objectives per employee, but also include employees with 0 objectives. Getting the necessary data in a query was not issue, but I can't figure out how to actually get a measure that states how many objectives each employee has.
Using an aggregated list I have been able to show in a table how many objectives each employee has (shows null for employees with 0), but I can't actually use that value for any calculations or graphs since it's not a measure.
Request clarification before answering.
| User | Count |
|---|---|
| 9 | |
| 5 | |
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.