Forum Discussion
Post ProdigyGrouping by day
Hi stribor45
You can create a date table, with a relationship to the calls table.
And use simple Dax measure :agents_on_call = DISTINCTCOUNT('Table'[Agent])I created a file based on your sample data, you can download it From this linkmore information about working with date tables:If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
It is classik matrix .
Put on rows day << agent name
On values measure that i created.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Yes, you can modifiy tooltip page size.
From tooltip sheet .Canvas format settings.
Post ProdigyRitaf1983 I do have Date table I looked at your example and it looks great. Is there a way to have the agent names there as well?
- Ritaf1983
Super User
Hi stribor45
If you count the agents and put their names ...it will show 1 for every agent ....
Is this what you want to show?- stribor45
I would somehow want to show for each day names of agents on duty so instead for each day showing
Sept 17 3 agents
Sept 18 2 agents
show
Sept 16 Agent A, Agent B, Agent C
Sept 18 Agent D, Agent A
- Ritaf1983
It is classik matrix .
Put on rows day << agent name
On values measure that i created.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.