topic Re: Operations Dashboard for ArcGIS choice of column to use in ArcGIS Dashboards Questions

Operations Dashboard for ArcGIS choice of column to use

SamvelArushanian — Wed, 25 Jul 2018 11:44:28 GMT

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‌

Re: Operations Dashboard for ArcGIS choice of column to use

XanderBakker — Wed, 25 Jul 2018 12:34:16 GMT

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.

Re: Operations Dashboard for ArcGIS choice of column to use

SamvelArushanian — Wed, 25 Jul 2018 12:55:22 GMT

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

Re: Operations Dashboard for ArcGIS choice of column to use

XanderBakker — Wed, 25 Jul 2018 13:43:37 GMT

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?

Re: Operations Dashboard for ArcGIS choice of column to use

SamvelArushanian — Wed, 25 Jul 2018 14:21:39 GMT

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:

Re: Operations Dashboard for ArcGIS choice of column to use

XanderBakker — Wed, 25 Jul 2018 16:12:57 GMT

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).

Re: Operations Dashboard for ArcGIS choice of column to use

SamvelArushanian — Mon, 30 Jul 2018 11:40:47 GMT

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.

Re: Operations Dashboard for ArcGIS choice of column to use

XanderBakker — Mon, 30 Jul 2018 12:43:06 GMT

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.

Re: Operations Dashboard for ArcGIS choice of column to use

SamvelArushanian — Mon, 30 Jul 2018 13:25:00 GMT

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.

Re: Operations Dashboard for ArcGIS choice of column to use

GiuseppeLancioni — Fri, 27 Jan 2023 14:01:35 GMT

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.