Filters

Write a Filter Formula using Magic ETL Filter Tile
Hey guys, so I am trying to utilize the filter formula feature in magic etl, but I can't seem to get it to work. When I run the following formula, no data appears. Using Excel, I performed a concatenate on all 517 websites that I would like to be filtered out from my data in order to build my formula. I've also used AND as…
Rename filter values to "Other"
I am trying to apply a filter at Card Level. For this specific card, I only want to show the filter options as either "Name 1" or "Other". I want the rest of the values to be bundled under "Other", so I only show two options for applying the filter: Name 1 Other Is it possible to do this via beast mode so it only applies…
Setting Default Datasets for Page-Level Filters
Hello Domo Community, I have a dashboard with page-level filters. The dashboard and the filter views have been shared with my company. I have chosen the Dataset I want the page-level filters to run off of, however, when other users log-in it switches to a different dataset that does not have all of the filters that I want…
How to set a default date-filter for iFrame-embedded dashboard?
Folks, First, this dashboard will be viewed embedded in a webpage iFrame. These seem to behave differently in a lot of regards, to please keep this in mind. Okay...I have 18 months of data and growing. I want users to arrive on this dashboard page and see the previous TWELVE months by default. But I want them able to…
Filtering by latest date in table
I have a dataset which appends updated content data on a daily basis (with a 1 day reporting lag). I want to have the table show the latest data, however am struggling to do so. I tried filtering by last 2 days, which works most of the day until 7 PM CT, when everything is filtered out because I guess the filter is going…
Ignore filters + include ALL entires of a specific measure in a formula, but filter other measures
I am tracking performance of a manufacturing process, and the various reasons parts get rejected. I can easily chart (Parts Rejected)/(Parts Run) aggregated by day for a reject rate, but I would also like to be able to separate the reasons out as a series. The formula I am after is then: (Parts Rejected by Filtered…
Card filter not showing all options
Hi there I have a card looking at the email domains of users. I want to filter out public domains like Hotmail and Gmail to look at institutional users. The filter is only showing me A-H of what is a long list. Is there a way to get access to the rest of block the domains I don't want to see?
Filtering using BeastMode with a plus
Hi, People! We have a uncommon situation here. We receive a dataset view by Snowflake with raw data and aggregated data and they are distinguished by a filed named "Data Type" 😶 Anyway, We have metrics in beast mode that look to raw data to calculate numerators and others that calculate denominators looking the aggregated…
Can you upload filters for values that don't exist yet?
My Domo data comes entirely from Brightspace datasets and we're in the early stages of user adoption of Brightspace. I'm running into the problem where I want to create filters, but Domo only lets me filter on existing data, I can't type in filter values pre-emptively. Example: I want to create a filter that shows how many…
Beastmode suggestion for a filter
I have a report that provides details on individual units it has a column that lets you know if that unit is rental or unrentable. it uses binary to illustrate this: bRentable 0 = “Unrentable” or “Offline” 1 = Rentable How can I write something in the analyzer that I can use as a filter that will replace 0 with Unrentable…
Quarter Filter On a dashboard
Hello, I need to add a filter that contains the list of quarters in the data. I can get the quarters to show in the card by using a beast mode QUARTER (Date Range), but am not able to get the quarter to show in the shared filters as a drop down list of values. The beast mode is shared to the data set. Quarters shown on the…
Can PDP be changed at the card level?
Good evening, I have PDP in place for a data set in Domo but am wondering if there's a way to open up the policy for specific cards. For example, I have a sales data set where, the way the PDP is set up, salespeople can only see their sales info when they log in. If they want to see where they rank against other…
New addition to Webform not flowing through all dataflows
I have a webform that houses in different columns site level details like store name, Region, and Site ID's across multiple sources. I use this to join with datasets so it makes it easy to filter for things like Region and Site's. I recently added a new site, and all the other details to this webform. if has flowed through…
Embedded Dashboard with Default Filter View does not display
Embed type = Private Programmatic filtering (i.e. no PDP) We've set up a dashboard with a default Filter View. It works within Domo for our internal users When we publish it using a private embed, the default filter view does not show. Users can still create their own filters using the top filter bar, but we want the…
What are "segments" in the context of page-level filters?
Hi, The documentation about page-level filters talks about the "Allow segments" option: But what are "segments", in this context?
Page Analyzer Links (or Deep Linking with Filters)
I am trying to create this BM calc but instead of the example shown in DOMO where you create a column with the link (Deep Link Col3) and also display the value (Owner Name Col1) I am trying to do it as one column but I am getting an error on the card. The link takes you to the page and you can see the filter is added to…
Google Analytics Exclude Filter
I'm working with a very large data set where most of the data is not tied to a GA Campaign. In order to reduce the amount of data I'm working with, I'd like to filter out all rows that do not have the value "(not set)". My current formula: " { "dimensionFilterClauses": [ { "filters": [ { "dimensionName": "ga:campaign",…
Comparative gauge and filters?
I am trying to build a gauge that shows a % for the currently selected company value in comparison to the % for the community as a whole. The problem i run into is that as soon as I filter the card to the current company, I no longer have the entire community's data to compare against? I don't see any way to just filter…
Is it possible to create a filter view based on a beast mode?
Hi, I have a beast mode attached to a dataset. I know the Card Analyzer lets you filter a card depending on te value of a beast mode. But, is it possible to create a dashboard-level Filter View based on the the beast mode?
How do I create a filter to show only the UPPERCASE records in a spreadsheet?
I am importing a CSV file. It has both UPPERCASE and lowercase entries in a single column. I would like to filter out all the records that are not UPPERCASE. The end result would be that all mixed case and lowercase entries would NOT be displayed.
Is there a way to prevent a card in a story page from using the page filters?
I have a page that shows info about a customer, and I would like to show info about that customer in relation to another group of customers. For example: Filters: Customer = Bob and Industry = Retail With those filters both active I would only see data about Customer Bob. I would like to have 1 card that shows the average…
Is there a way to filter a card based on a sub-string in a text field?
I have a text field that is delimited by '|'. I would like a user to be able to use a quick filter that allows users to find a sub-string of the text field. Regions Covered Row1: North|South|East Row2: East|West Row3: West Row4: East|South I would like to be able to filter if a row contains 'East'. (Yes, I know I could do…
Using an interaction as a filter on another story page?
I have a card on a page that gives high-level information about a set of customers in a table. When one of the customers is clicked in a table card, I would like Domo to open another story page and use the clicked customer as the value of the customer filter. When I change the interaction to open another story page, it…
Tableau-like Parameter actions
I am trying to allow a user to filter a chart that uses an aggregation. My data looks like this: I want a user to be able to choose 'Apple' and then the ensuing line chart would show percentage of items each day that were apple (40% over 1/1, 30% over 1/2, and 60% over 1/3). In tableau, I would set up a parameter (p_fruit)…
Use card with drilldown as filter on a page
Hi! I have created a dashboard where I have a map that is drillable (it's a map that goes from a state view to a zip view) but since I have changed the interaction option the card is no longer interacting with the rest of the cards on the page. Would it be possible to keep both functionalities ( when a user clicks on a…
Diferent date ranges on a Dashboard
Im building a dashboard and some cards have diferent date ranges, some have yesterday as default and some have this month, at this point dashboard works fine, but if we try to modify date ranges from the dashboard lets say lat month its no working, will show blanks. am i missing a configuration? thanks in advance.
Domo Stories: Passing page filters through when linking to another card
Does anyone know if it is possible to pass page level filters through when your interaction with a card on a dashboard is to link to another card? From I can tell it does not look like it is possible. I also have visual bugs when using a slider filter and a checkbox filter concurrently has anyone else seen this?
Unable to select apply to selected cards in card interaction settings
I have built a dashboard with about 8 cards on it. I have a filter card that I just want to have it affect only 2 cards. However, when I go to Interaction Settings and try and change it to only apply to selected cards, the option is greyed out. See screenshot below. I have been able to do this before, so I'm unsure as to…

Upcoming Events

Connections Tour, Denver
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour, Los Angeles
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour, San Jose
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour, Atlanta
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…
Connections Tour, Washington D.C.
Spend a half day with your peers, Domo enterprise customer speakers, and product leads to explore real-world use cases and new platform innovations. Whether you’re a power user or just starting to learn about Domo, don’t miss this opportunity to learn from like-minded professionals about how they use data to multiply their…

Filters

Discussion List