Creating a Serial Chart with Survey123 data

[Zelong]

I am trying to create a serial chart in a dashboard using data from a survey 123 form that I use to track drone missions.  My goal is to create a chart that looks over all of the surveys and give me the total mission numbers of departments divisions, then grouped by department that I fly for.  Often a flight has more than one department that it is being flown for so in survey123 the current serial chart will look like this:

 What I want is a chart that groups the departments so I a want a bar for Public Works, a bar Engineering, etc

I think arcade is going to be the way I must do this or would business analyst or experience builder be a better way to go?

[Neal_t_k]

Assuming you don't already have a field that departments are categorized in?  If so then yes you can use Arcade for this, Basically you want to create a new field with a new categorization.   Creating a new data expression to something like the example here I think would work:

https://community.esri.com/t5/arcgis-dashboards-questions/split-pie-chart-by-greater-than-less-than/...

Obviously you would have to update the code to your source data and you would have to expand the when statement to encompass all your existing categories. And then also add any other fields to the new feature set for your queries.

var DeptCat = When(DeptDiv == 'Building_Services', 'Engineering', DeptDiv =='City_Manager' || DeptDiv =='City_Manager_Communication', 'Public Works', 'n/a');

https://developers.arcgis.com/arcade/function-reference/logical_functions/#when

If you can modify your Survey123 form and you wanted to take care of it there instead. You could add a calculation question to add the new Department category:   If(${DeptDiv} = 'Building_Services', 'Engineering' if (${DeptDiv} ='City_Manager' or ${DeptDiv} ='City_Manager_Communication', 'Public Works','n/a')

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformexpressions.htm#ESRI_SECTION1_9C76...