
Announcements
Hi! I have a Column Chart based on the below 3 SharePoint Columns:
I am using the below formula to:
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:
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))