KPI and Sumo cards provide options for performing in-depth data analysis by applying Card Filters to your data. For both card types, you do this in the Details view, using the Filters tool.
For information about applying Filters to cards in a page, see Applying Page-Level Filters. For information about using other analysis tools, see Drilling into Data and New Analyzer Tools (Jan. 2017).
For a KPI card, you click the icon. This allows you to apply Card Filters to the chart data. Filters you apply in a Details view are applied only to your own personal Domo instance—others who view this Details page do not see your Card Filters. Also, these filters are temporary. When you leave the Details view, they are removed. If you want to apply permanent Filters to the chart, you may do so in the Analyzer. For more information about applying both temporary and permanent Filters, see Adding Filters to Your Chart.
CASE WHEN `column` IS NULL then 'Filter' ELSE 'Do not Filter' END
For more information about Beast Mode, see Transforming Data Using Beast Mode.
For a Sumo card, in either view you can analyze your table data by applying dozens of different options, such as Filters, number formatting, conditional formatting, date grains, sorts, and the like. As with analyzing data in a KPI card, Sumo card Filters are applied only to you and are temporary, unless you make permanent changes in the Edit view. For more information about the available options for analyzing Sumo data, see Sumo Editor Layout and Adding a Sumo Card.
Video Series - Filtering Pages and Cards
Part 1 of 2
Part 2 of 2
Video - Sharing a Filtered Card