Creating an indicator to show worker attendance

ryanEvanczyk

We use a dashboard for employee performance reviews for the end of our ski season. Info for this dashboard comes from a daily record survey we fill out every morning saying who is on duty, who called out sick, who is off campus for a work thing, etc. 

The survey questions are multiple select type. I can't seem to get the indicator to accurately show the number of times a name has been selected in the survey results for the questions. Adjusting the data to show the statistic as a count for the "On duty" field yields "0" in the indicator unless the selected name is the only answer selected for a date. For example, when the employees are selected for the "On duty" question, which always has more than one name selected for the multiple select question type, the indicator does not single out how many times a name is selected for this field when the dashboard is filtered by name using the category selector in the header. Is there any way to fix this so the indicator can read every instance a name is selected whether they are the only selection or not? 

MobiusSnake

You'll want to create a Data Expression that splits comma-delimited values into multiple strings, then create one feature in your Data Expression for each split part.

Here's a contrived example, I took the scoresheet from the Toronto-Ottawa game last night and put it into a table with a single field, the field has the goal scorer and players that assisted, comma-delimited:

Unassisted goals only have a single name, assisted goals may have two or three names.

For the indicator I want to display total points, so I'll want to expand this out to sixteen records (one record per point), this Arcade will do it:

var myPortal = Portal("https://(org_name).maps.arcgis.com");
var scoresheetFeatureSet = FeatureSetByPortalItem(myPortal, "(item_id)", 0, ["points"]);

// Iterate through the records, splitting each into separate records for each part.
var playerFeatures = [];
for (var scoresheetFeature in scoresheetFeatureSet) {
  var pointsCsv = scoresheetFeature["points"];
  var pointsNames = Split(pointsCsv, ",");
  for (var nameIdx in pointsNames) {
    var playerFeature = {attributes: {name: pointsNames[nameIdx]}};
    Push(playerFeatures, playerFeature);
  }
}

// Create a feature set from the features list.
var returnFeatureSetDict = {
  fields: [{ name: "name", type: "esriFieldTypeString" }],
  "geometryType": "",
  "features": playerFeatures
};
return FeatureSet(Text(returnFeatureSetDict));

 

You'll probably want to have your employee names coming from a separate "master list" table, and have a List element driven by that.  Create an action that filters the indicator's Data Expression on your List selection.  I did this and here's what it looks like when I click on J. Sanderson, who had two points last night:

This is probably the simplest approach, but you could also create a Data Expression that has two fields, name and attendance count, and instead of simply creating a list of names, you could create a dictionary of counts, and return a distinct list of names with a count beside each one.  This could let you do some cool things like pulling in additional info about the person from other sources, but may not work so well if you have someone with an attendance of zero.