Allow custom categories

Idea created by megan.fong@gov.bc.ca on Aug 14, 2018
    New
    Score50
    • megan.fong@gov.bc.ca
    • KateW_BOPRC
    • tom.rippetoe
    • ADALI_governmentofbc
    • Julie.ScottAshe_bcgov03

    Sometimes, features may need to have multiple values in the same field. Since a feature cannot take multiple coded values, I have put the values together for each feature using a comma delimiter, like how Survey123's select multiple does.

    For example:

    UnitActivity
    1A,C,D
    2B,C,E,G
    3F
    4E,F

    And so on. A lot of activity combinations can occur. I want to be able to filter by having a checkbox for each activity so that my map and widgets reflect my selection like this:

    A
    B
    C
    D
    E
    F
    G

     

    Currently, categories by grouped values takes each activity combination as a unique value; it doesn't recognize ',' as a delimiter. Custom expressions could help in this case, as a wildcard statement along the lines of WHERE Activity LIKE '%C%' as the category and C as the label would find all the units with activity C. I've tried something like this by overriding categories in the grouped values option, and inputting similar statements under the defined values option rather than grouped values, but it turns out that the category must be an exact match to the field value.

     

    Allowing custom expressions to create my own categories (or an ability to specify and recognize delimiters to automatically create categories) would be useful.