on 2025 Feb 27 8:10 PM
I created a data base with #Story and want to have aggregate type count for objective ID so that i can see for each employee row how many objectives they have>
Eg
Name Department objectiveCount totalweightage
AAAA Marketing 4 100%
BBBB Sales 5 120%
This was easy in table report but in story report query builder the aggregate type is missing count.
Request clarification before answering.
Firstly, you build a table with employees and goals in the Designer mode with a Table widget, not in the Query.
Secondly, when you create a table widget, just add Employees (and other data needed) as a Dimension and a relevant Measure (Count or any custom built measure) and it’s totally possible with the Agregated type of table and the Cross-tab type. If you need to have also %, you need to create an additional measure for that first and then add it to your table. Everything is done in the Designer mode (not Query).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
7 | |
4 | |
3 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.