Operations Dashboard for ArcGIS choice of column to use

[SamvelArushanian]

Hi,

For the first time I used the dashboard functionalities of ESRI today.
I discovered a problem where I can’t find a solution for.
I have a layer with 9 columns, all of them have the same domain.
I have configured a serial chart that displays data from column 1 with filter for last week.

The problem: I do not want to add too many tables, so it would be great if I could add a dropdown list of column names to select serial chart data. Therefore, I do not want to invoke a fixed category (column name) but specify a variable dropdown menu. (pic1)

Greetings,

Samvel

#dashboard‌ #operations dashboard for argis‌ #survey123‌

[XanderBakker]

Can you elaborate a little more about why the data is in 9 fields and what it represents. I deduced that it has to do with dog poo and your domain probably represent a count (how many were found in a certain area?). If you have 9 fields I wonder what those fields represent. The reason I ask is that maybe the format of the data is not ideal for the type of graph you want to create. 

[SamvelArushanian]

there are 9 columns no fields. domain consists values(text) 1,2,3,4,5 and na.
it is simple to create a serial chart, but I want to be able to choose data from which column serial chart should display.

something like this:

Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9
1	9	3	4	5	6	7	8	9
2	1	na	3	4	5	6	na	8
3	2	1	2	3	4	5	6	7
4	3	2	1	2	3	4	5	6
5	4	3	2	1	na	3	4	5
6	5	4	3	2	1	2	3	4
7	6	5	4	3	2	1	2	3
8	7	6	5	4	3	2	1	2
9	8	7	6	5	4	3	2	1

[XanderBakker]

What does each field (column as you wish) represent? Each record has geometry too? What does each record represent? Why does a record has 9 attributes with the same domain? I assume you have more fields (at least a date field to be able to filter the last week)? What would you like to be able to visualize?

[SamvelArushanian]

I can not explain the whole content issue, but say quality of apples.
Column 1 is appes, column 2 pears.
So I want to see how often value 5 (see picture 2) occurs in column 1 (apples). and if I choose pears in categories (see pic3), I want to see values of pears in the same table.
I would like to share the dashboard that I work with you, but I can not share the data.

pic2:

pic3:

[XanderBakker]

OK, so let's talk fruits... what I am trying to explain is that your data format may not be suitable to obtain the result you want. I would probably transform this:

Date	Apple	Pear	Strawberry	Banana	Grape	Orange	Kiwi	Nectarine	Pinapple
25-jul	1	9	3	4	5	6	7	8	9
24-jul	2	1	na	3	4	5	6	na	8
23-jul	3	2	1	2	3	4	5	6	7
22-jul	4	3	2	1	2	3	4	5	6
21-jul	5	4	3	2	1	na	3	4	5
20-jul	6	5	4	3	2	1	2	3	4
19-jul	7	6	5	4	3	2	1	2	3
18-jul	8	7	6	5	4	3	2	1	2
17-jul	9	8	7	6	5	4	3	2	1

... into this:

Date	Fruit	Observation
25-jul	Apple	1
25-jul	Pear	9
25-jul	Strawberry	3
25-jul	Banana	4
25-jul	Grape	5
25-jul	Orange	6
25-jul	Kiwi	7
25-jul	Nectarine	8
25-jul	Pinapple	9
24-jul	Apple	2
24-jul	Pear	1
24-jul	Strawberry	na
24-jul	Banana	3
24-jul	Grape	4
24-jul	Orange	5
24-jul	Kiwi	6
24-jul	Nectarine	na
24-jul	Pinapple	8
etc (table truncated)

This allows you to select/filter the fruit and date and show several fruits in the same graph (I did not test this though).

[SamvelArushanian]

I cannot change the structure of my data.
And I am not going to fill a separate survey123 form for each topic.

For each location questions are asked about the number of subjects, and score is given for each subject. You cannot expect from a person to fill a separate form for each subject in one location.
I'm not going to transform data every day because I want to use real-time data.

translated with google.

[XanderBakker]

It would have been helpful to include this data in the question. The fact that the data format is based on questionnaire build with Survey123 and that the data format cannot be changed. The fact remains, that the data format is not optimal for the type of visualization you want to achieve in Operations Dashboard.

Perhaps you could have added some calculated fields in the Survey to be able to obtain the result for that, but it is a bit too late for that if (part of) the field work is already done.

[SamvelArushanian]

In 2 weeks I have to make a new survey123 from with some information. It will be a survey123 form with 12 question, where possible answers is score from 1 to 5.

What is the best structure and what kind of calculation fields do I have to add to make a dashboard optimal?

Where is no data yet, only 12 questions with possible answer 1 to 5.

[GiuseppeLancioni]

Any news about this topic? I have the very same conceptual problem and can't figure out how to solve it.

More in detail, I have a large amount of columns (114), each representing a statistical indicator about population, and up to 7903 records representing geography (administrative borders). So a huge dataset.

The idea is to add cascade selectors to filter indicators by year, type and target population, so to obtain only a few to choose from. But how to do this? 

Any help much appreciated.