Hi! I have a Column Chart based on the below 3 SharePoint Columns:
- Month Created
- ID
- Entity
I am using the below formula to:
- Group the ID values by Month Created
- Filter out the UK Entity
It works great, but now I want to add a second series whereby I split out the IDs for each month across the different entities.
For example, my Column Chart would show the following:
- November
- Italy: 3
- USA: 4
- France 1
- December
- Italy: 1
- USA: 5
- France 2
How can I add the "Entity" column into the below formula?
AddColumns(
GroupBy(
Filter('Reactive Support Escalations', 'CMS Entity' <> "CMS UK"),
"Month_Created",
"DATA2"),
"MonthCreatedChart",
CountRows(DATA2))


Report
All responses (
Answers (