I had two tables originally - one with all "Notifications" created and a table of all employee user names. I created a mapping table to determine which Notifications were created by the employees in my list.
"Created by" as [User Name],
FROM [lib://1C Metrics/Employee ID Ops Centre.xlsx]
(ooxml, embedded labels, table is [Employee ID and Ops Centre]);
ApplyMap('MapEmployeeNotifications',[User Name],'No') AS RaisedByField
I want to create a pie chart that counts the number of each type of Notification (Notifictn type) but ONLY for those Notifications that were created by the employees in my list (RaisedByField).
I've created a pie chart now:
But this includes all of the notifications from the first table, and not only the ones that were RaisedByField
I am able to get the result I want by adding a filter pane for "RaisedByField" and only selecting "Yes", but can I embed this into the pie chart somehow?