As of 3.26, it is now possible to exclude a field that exists in the data table from its corresponding visualization.
Possible Use Cases
This could be useful in situations where you want to:
- Chart a table calculation, but not the fields that are used to calculate it
- Make a single value visualization from a table calculation
- Sort by a field that you don’t want to see in your chart
- Apply a reference line to a table calculation (if it’s the first series included in the chart)
Feel free to post additional use cases in the comments below!
How It’s Done
From the data table, simply click the gear button that corresponds to a field, and select “Hide From Visualization.” An eye icon will appear to let you know that the field is hidden.
Then, chart as usual!