Skip to main content
waffle.svg
Domo Knowledge Base

Filtering Data in a Card Details View

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.

Note: If you get an error stating that your filters contain no values, this indicates that the data has already been filtered out by previously set Analyzer or page-level filters and no rows are returned. 

Note: It is possible to filter on NULL values, but to do so you must use Beast Mode to convert the NULL values into values that can be filtered. For example:

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.

Training Video - Filtering Pages and Cards

Learn how to apply filters to pages and cards.

Part 1 of 2

 

 Part 2 of 2

 

Training Video - Sharing a Filtered Card

 

 

Note: The product training videos are for Domo customers and clients only.