Operations Dashboard for ArcGIS choice of column to use

1863
9
07-25-2018 04:44 AM
SamvelArushanian
New Contributor II

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

0 Kudos
9 Replies
XanderBakker
Esri Esteemed Contributor

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. 

0 Kudos
SamvelArushanian
New Contributor II

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:

Column1Column2Column3Column4Column5Column6Column7Column8Column9
193456789
21na3456na8
321234567
432123456
54321na345
654321234
765432123
876543212
987654321
0 Kudos
XanderBakker
Esri Esteemed Contributor

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?

0 Kudos
SamvelArushanian
New Contributor II

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: pic2

pic3: pic3

0 Kudos
XanderBakker
Esri Esteemed Contributor

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:

DateApplePearStrawberryBananaGrapeOrangeKiwiNectarinePinapple
25-jul193456789
24-jul21na3456na8
23-jul321234567
22-jul432123456
21-jul54321na345
20-jul654321234
19-jul765432123
18-jul876543212
17-jul987654321

... into this:

DateFruitObservation
25-julApple1
25-julPear9
25-julStrawberry3
25-julBanana4
25-julGrape5
25-julOrange6
25-julKiwi7
25-julNectarine8
25-julPinapple9
24-julApple2
24-julPear1
24-julStrawberryna
24-julBanana3
24-julGrape4
24-julOrange5
24-julKiwi6
24-julNectarinena
24-julPinapple8
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).

0 Kudos
SamvelArushanian
New Contributor II

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.

0 Kudos
XanderBakker
Esri Esteemed Contributor

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.

0 Kudos
SamvelArushanian
New Contributor II

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.

0 Kudos
GiuseppeLancioni
New Contributor

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.

0 Kudos