Grouping by day

[stribor45]

Is there a way to produce a visual that would show how many agents were on calls  each day? Sample data is attached.

Sample data 

[Ritaf1983 · Accepted solution]

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 link 

more information about working with date tables:

https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[Ritaf1983 · Accepted solution]

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?

[Ritaf1983 · Accepted solution]

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.

[Ritaf1983 · Accepted solution]

Hi @stribor45 
It is a table and I suggested using a matrix.
I updated the sample file with this option + graph with a tooltip.

You can download it from the same:Link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[stribor45]

@Ritaf1983 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 · Accepted solution]

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 · Accepted solution]

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.

[stribor45]

[Ritaf1983 · Accepted solution]

Hi @stribor45 
It is a table and I suggested using a matrix.
I updated the sample file with this option + graph with a tooltip.

You can download it from the same:Link 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[stribor45]

is there a way to make this white area around the tooltip smaller?

[Ritaf1983 · Accepted solution]

Yes, you can modifiy tooltip page size.

From tooltip sheet .Canvas format settings.

[Ritaf1983 · Accepted solution]

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 link 

more information about working with date tables:

https://radacad.com/power-bi-date-or-calendar-table-best-method-dax-or-power-query

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.