-
Filter a DataSet with values from a Google Sheet?
Hello, I have a dataset that I would like to be able to dynamically filter based on values in a Google Sheet. This feels like a fairly simple MagicETL to me but I'm stumped at the moment. In short, the PROD dataset is good to go and I would ideally be filtering one column from the PROD set based on values in one column in…
-
shield and funnel icons
I have several cards where the filter funnel and the PDP shield block the bottom left cell on a chart's associated data table. I read something out here from early 2021 about not being able to hide those. I was hoping that had changed. If it hasn't is there a way to left justify the numbers in the data table to avoid the…
-
Possible to update multiple filtered dashboards
Hello, I currently have a dashboard of about 40+ cards that pulls data from multiple data sources and am wondering if it's possible to create duplicates, with each duplicate having a filter applied (ideally, that can't be unfiltered). Essentially what I'm hoping to do is to be able to just update the dashboard with…
-
Is there a way to suppress sections (collections) in a page/dashboard?
I would like my users to be able to suppress certain cards or collection of cards prior to exporting pages. Some times the users want more details for certain clients, and instead of having multiple pages, some with less data, and some with more, I thought it would be great if they could just filter on sections, that would…
-
Filter Cards "AND" Behavior
The filter cards default to being an "OR" behavior, i.e. selecting Product A and Product B will result in the page showing all rows of Product A or all rows of Product B. It would be great if you could change that to be an "AND" operation.
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this…
-
Card Level Interaction Filters
This is a pretty straight forward question. When interaction filters are enabled on a card does it only work on cards that are running on the same dataset with the interaction enabled? For example I can 1 card that I want to filter other cards, some cards are on the same dataset, some are not. I thought that similar to…
-
PDP Policy Simple Filter - don't see value in dropdown list
I am trying to filter by store number (Store No) for a particular PDP policy and I'm searching "8". The value is definitely in the dataset, but it does not appear in the dropdown list and I'm assuming this is due to some sort of limit on how many values can be displayed in it. Is there a keyword or phrase I can add to the…
-
60 days since last pmt beastmode
I have a payment column called LastPmtDate, it exactly what it sounds like. What I am wanting to do is write a beastmode to be used as a filter to filter on only those that our 60 days or greater from that payment date.
-
Possible To Update All Cards On A Dash At Once?
Hi - seeking recommendations on a faster/better way to update datasets and dimensions for all cards on a dashboard. Currently clicking through each card (80+ on one dash) to update to a new dataset, and also to remove a filter. Going to add a dash-level filter once all the card-level filters are removed, but wondering if…
-
Trying to figure out how to filter out top 20th percent of data by week in domo graph
I'm trying to eliminate outliers from my dataset (top20% highest score let's say) by week. So I'd need to filter out (by rank) top 20% of scores from each week and then graph it on a line graph. My data is dynamic and it changes every day so I can't rank the entire data set. I need to rank by week. I've seen people talk…
-
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",…
-
Display a Card's Quick Filters on Stories (+ Quick Filter Sorting)
I would love to enable a card’s Quick Filters to show up along with the card when designing stories. I often design filters at the story level to replicate the quick filters the user would see if they open a card in full screen, which seems like potentially unnecessary extra work - and in the case that they are based on…
-
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…