Chartcolumn filter based on O365 Department

[Dhinesh28R]

Hi,

      I have  a chart column in my app.

This chartcolumn how to Filter by sender department (SenderName) from 0365 group as well as receiver department(ReceiverName) .How to get a Different separate chartcolumn for both Sender and Receiver.

Am using follwing formula,

AddColumns(GroupBy(AddColumns(Filter(List,Month(CreatedDate) = Dropdown3.Selected.ID, Year(CreatedDate) = Dropdown6.Selected.ID), "TypeField",Department,"SName",SenderName), "TypeField","SName"), "CountbyStatus", CountRows(SName))

But i want a different chartcolumn based on department from O365?

Is it possible?

Thanks,

Dhinesh

[rubin_boer · Accepted solution]

hi @Dhinesh28R what does you list look like?

Lets assume something like CreatedDate, Department, Sender, Receiver 

For simplicity i will leave out the dates as that is just a filter for your data anyways ok.

Create a collection and add it to a button, collection: 

ClearCollect(_BarChart,
{Dpt:"SP",Sender:2,Receiver:5},
{Dpt:"SP",Sender:4,Receiver:2},
{Dpt:"HR",Sender:5,Receiver:2},
{Dpt:"SP",Sender:2,Receiver:4}
)

Here it is in a gallery

Now lets add that to a bar chart with sender and receiver. Set the number of series at 2

Bar Chart Items = _BarChart

The above shows you how to add multiple series to a chart

Now lets group that at department level (dpt)

Bar Chart Items = AddColumns(GroupBy(_BarChart,"Dpt","Departments"),"Sender Total", Sum(Departments,Sender),"Receiver Total",Sum(Departments,Receiver))

Hope you can use this is your chart

[Dhinesh28R]

@rubin_boer ,

Thanks man. Its working man.