1 Reply Latest reply: Feb 8, 2017 9:52 AM by gareth wilson RSS

    How can I create a pie chart that counts the number of a type of field against a field that I've created from a mapping table?

    Elise Reiter

      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.

       

       

      AllNotifications:

      LOAD

          Notification,

          Notif.date,

          "Notifictn type",

          Description,

          "Created on",

          "System status",

          "User status",

          "Functional Loc.",

          Equipment,

          "Changed on",

          "Created by" as [User Name],

          "Changed by",

          Coding,

          "Completn date",

          "Operations Centre",

          Township,

          "Req. start",

          "Order",

          "Main WorkCtr"

       

      EmployeeNotifications:

      LOAD

          "User Name",

          "Employee Name",

          "Building Code"

      FROM [lib://1C Metrics/Employee ID Ops Centre.xlsx]

      (ooxml, embedded labels, table is [Employee ID and Ops Centre]);

       

       

      MapEmployeeNotifications:

      MAPPING LOAD

         [User Name],

         'Yes'

      RESIDENT EmployeeNotifications;

       

      New_Table:

      LOAD

         [User Name],

         ApplyMap('MapEmployeeNotifications',[User Name],'No') AS RaisedByField

      RESIDENT AllNotifications;

       

      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:

      Dimension=[Notifictn type]

      Measure=count([Notifictn type])

      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?