Forum Discussion
Post ProdigyGrouping by day
Is there a way to produce a visual that would show how many agents were on calls each day? Sample data is attached.
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.
9 Replies
- Ritaf1983
Super User
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.
stribor45I 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