nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to override a filter in Indicator with a Category Selector?

RudyJamet

I use an indicator as a counter that displays, by default, the total count of 2 types of features ("Status" = "A" and "Status" = "B") with a filter that looks like "Status" not equal "C". For ex: "A" (281) + "B" (4) = 285. "C" = 2

One of my category selectors, in the Side Panel, is using the same hosted feature layer source as the indicator, and is called "Status". It is also connected to the indicator. In a dropdown list, the user can select "A", "B" or "C". When "A", or "B" or "C" is selected, I want the counter indicator to display the number of "A", or "B" or "C". That is, going back to the example: 281, or 4, or 2.

Now, when the user selects "C", the indicator displays 0 instead of 2. Which is expected since "C" is filtered out by default in the indicator. How can I make the selection "C" override the filter in the indicator so that it displays 2 and not 0?

Find more posts tagged with

ArcGIS Enterprise

Accepted answers

Neal_t_k

You have to set up your indicator a little different, the expression is already doing the calculation so you don't need to do further statistics. Note: no filter and the indicator has 4 pages, each page should already be the total count of items in that category. In the example below "count" is not a statistic in the instance but a column heading from the new feature set you created with the expression.

Then set your category selector like this:

Then your default state is A+B, and users can still select A or B or C. When a user selects a category they are actually selecting 1 of the 4 pages from above. You would have to modified the Arcade for more/different categories.

All comments

RudyJamet

Great Neal! I tried the way you explained, and it worked. Thanks again.

Neal_t_k

Then set your category selector like this:

RudyJamet

I tried the script and the indicator actually displays the count of categories (1. to 4.) and not the count of features per category. I am guessing it's to be expected but then I don't know how to proceed because I am not sure what you mean by ditching the hardcoded filter and setting category A + B to the default on the selector.

RudyJamet

Yes, the Arcade script might be the solution, and what you proposed is somewhat similar to the expression I used. I will try your expression and see how it works. Thanks Neal.

Neal_t_k

Could you do 2 indicators, but that would be similar to using the reference.

I think Arcade may be the way to go, making a new feature set and recategorizing your data. Then ditch the hardcoded filter and set A and B to the default on the selector. In the example below that is why the category is "1. A and B" so it show first in the list.

1. A and B (default)

2. A

3. B

4. C

var fs = FeatureSetByPortalItem(
    Portal("https://www.arcgis.com"),
    "<ItemID>",
    0,
    ["Status"],
    false
);

var grouped = GroupBy(
    fs,
    ["Status"],
    [{
        name: "Total",
        expression: "1",
        statistic: "COUNT"
    }]
);

// Get Count Value
function getCount(statusValue) {

    var row = First(Filter(grouped, "Status = @statusValue"));

    return IIF(IsEmpty(row), 0, row.Total);
}

var outDict = {
    fields: [
        { name: "Category", type: "esriFieldTypeString" },
        { name: "Count", type: "esriFieldTypeInteger" }
    ],
    geometryType: "",
    features: [

        {
            attributes: {
                Category: "1. A and B",
                Count: getCount("A") + getCount("B")
            }
        },

        {
            attributes: {
                Category: "2. A",
                Count: getCount("A")
            }
        },

        {
            attributes: {
                Category: "3. B",
                Count: getCount("B")
            }
        },

        {
            attributes: {
                Category: "4. C",
                Count: getCount("C")
            }
        }
    ]
};

return FeatureSet(Text(outDict));

RudyJamet

Thank you Neal for your input. I thought about setting a Reference but we decided not to use it because it might confuse our customers. I tried with an Arcade expression instead of the source layer directly but, even though it seems to be working when I test it, somehow Dashboard thinks it's invalid.

Neal_t_k

Have you looked at using the "Reference" function. It allows in an indicator to have two separate values from the same or different sources and filtered differently. You might have to play with labels so users understand what they are looking at, but if I am understanding correctly might work for what you are trying to do.

Indicator—ArcGIS Dashboards | Documentation

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.