Gist makes it easy to create filters and charts from categories in your data. For example, if you have a dataset of people and you are looking to visualize your data by gender, your data might include a field called "Gender" with two possible values, "Male" and "Female". But what do you do when you have fields that can include multiple categories each? Fortunately, Gist has a solution for that as well.
Take this example of a dataset of the Rolling Stone Magazine Top 500 Albums.
Each album has a "Music Genre" and "Subgenre" field, and both fields can include one or more categories. For example, an album might have the music genres "Rock" and "Blues", and the subgenres "Blues Rock", "Rock & Roll", and "Classic Rock". The values in this dataset are comma-separated, resulting in values that read "Rock,Blues" and "Blues Rock,Rock & Roll,Classic Rock".
When you first create your visualization and upload your data, your fields tab will look like this. The fields "Music Genre" and "Subgenre" are initially inferred as text fields.
Next, you might add both fields as filters.
This produces the following results in the Gallery View of the published visualization. Note that the filters include the comma-separated values from the source data.
The same is true for other views, such as the Pie Chart view. The Pie Chart segments include the comma-separated values from the source data, just like the filters.
Gist makes it possible to separate out comma-separated values (or values separated by another character), in order to parse them separately for filters or in views. In Gist, these are called "delimited fields". You can process delimited fields in the Fields tab.
Back in the Fields tab, you can see both fields listed. Click on the pencil icon to edit each of the fields.
In the Field settings, click the button "Create Delimited Field".
This will open another window with the settings for a delimited field. Here, you can change the "Display Name" like before, but you also have the option to specify a "delimiter".
In the text field below the "Delimiter" label, you would type a comma and press RETURN. (If you delimiter is any other character, such as a semi-colon, the process is the same; type a semi-colon and press RETURN). Then click "Save".
Back in your list of fields, you will be prompted to save your settings. Go ahead and click "Save".
This will process your data, and after which you will see a new field at the bottom of the list, with the same name as the originating field but with "Delimited" added at the end. To change the name, click the "Edit" option again.
In the field settings, change the "Display Name" by typing the new field name in the text field, and click "Save". Like before, make sure you include this new field in your filters and in your view settings.
Now, if you look back at the filters in the published visualization, you can see that they are properly grouped, and that the comma-separated values are processed as independent categories.
The same is true for other views like the Pie Chart view, where the segments now accurately reflect the categories in your data, with comma-separated values properly grouped.