-
Magic ETL: How to REMOVE Rows Meeting a Two-Column Criteria?
As part of my ETL, I'm trying to REMOVE rows that meet the following criteria: column 1 is NOT NULL AND column 2 is NULL So if column 1 has any value in it AND column 2 is empty, then remove those rows from the data set. I was trying to figure out how to create a Filter Formula for this, but it seems to be designed for…
-
Domo Everywhere - Embed Filtered Views
Hello! Is there a way to use Domo Everywhere to create links to specific filter views? I have clients who want to see their marketing campaigns filtered to specific regions so that they don't have to teach their stakeholders can immediately see a specific page view without needing to manipulate the filters. I know this…
-
Add Saving Features for Publication Group Users
We have filtered views which we share with customers via Domo Publication Groups. Those users would like to reduce manual efforts on their side by creating and saving page filters (similar to page filters for regular user accounts) and being able to create filtered scheduled reports which can be emailed to themselves. This…
-
Dropdown selector filter card not displaying all values
It's not that many, not sure why there not all populating. Thanks.
-
How can we apply drill down functionality between two dashboards in domo?
I have two dashboards. When user click on 1st dashboard's any record then it will redirect to 2nd dashboard and also apply filter on 2nd dashboard according to 1st dashboard's report.
-
Radio Button Filter Card - Set the default selection?
Hello, I have a Radio Button Filter Card on my page. I'd like a default value to be selected on this card. However, I can't seem to find a property that enables that. When i use Page filters to set a default selection the user can clear the filter, or filter on multiple values (which defeats the purpose of the Radio Button…
-
Can we add back button in domo dashboard?
I have two dashboard. I have added hyperlink in table data in one dashboard which is navigate to second dashboard with pfilter. It is working properly but once I navigate to second dashboard then I am not able to back first dashboard. I need to refresh the whole page. Can anyone have idea about it? How can I navigate to…
-
How can I use domo.onFiltersUpdate to stop App refresh while still getting filtered data?
We have a Custom App on a dashboard with multiple filter cards. We like how the app responds to changes in the filters, but we would prefer it not have to refresh. I found domo.onFiltersUpdate and see that the filter data is passed into the function for use in the event handler, but it's unclear how the filter data can be…
-
Getting incorrect result while computing an output using Beast mode
Hi, The below beast mode works perfectly when only 'metric A' is selected as a filter. However, when 'metric A' and 'metric B' is selected as filter under 'metrics' then the resulting value changes. Note: I have attached a screenshot when the correct value is coming with only metric A as 72224, whch changes to 72213 with 2…
-
How do I filter duplicative entries when two date fields are involved? (entry & modified dates)
Hey Domo Smarties! [Annotated Screen Cap Below] What's the best way to filter out duplicate rows according to the latest modified date in an ETL? Desired Result: One unique entry by "start date" and "model" with the latest "ob modified date".
-
How to apply a filter across 2 data sources with filter column having diff names in the data sources
I have a column called Frequency (values could be daily, weekly, monthly) in data source 1 and a column called Cadence (values could be daily, weekly, monthly) in data source 2. How can I join these two columns to apply the filter on both data sources?
-
Magic ETL | Remove Duplicates Old Raw
Hi, Assume my data like that I want to become If I use Remove Duplicates in ETL, it only keep the old row. What should I do now ? Many thanks
-
Filtering Rows without Displaying Them / Same-Store Comparison
I have a dataset of sales data with one record per store, per day, across multiple years. I used @jaeW_at_Onyx's offset date table solution to get YOY and POP comparisons; but I'm not positive that's relevant to my [hopefully simple] question. I'm trying to create a filter for same-store comparisons. I am defining…
-
Domo Everywhere Default view/filter
Hi All, I'm trying to create embedded dashboards that will show multiple years worth of outcomes. I would like the end-user's view to default to the most recent year's data, but then be able to manipulate the data using a slicer filter card. So, if we have data from FY19, FY20, FY21, FY22, and FY23, we would like the…
-
Eliminating Null Values in Slicer Card Type
I have a dataset which is currently duplicated except in one column (Delivered Price) 1/2 of the dataset is displayed in USD and in the other 1/2 of the dataset that same column (Delivered Price) is displayed in CAD. For users of my dashboard, I want to provide a option to view the underlying data in either CAD or USD, but…
-
Population calculations in beast mode?
So, I've got a dashboard in which I'm trying to show the population over time at a facility for one of my cards. So, x-axis should be a date, and y-axis should be how many people were present at the facility that date. The dataset we have has a row for each client, and two of the columns are date admitted and date…
-
Re-order page filters
It would be nice if we were able to re-order the filters on the dashboard page. Currently if you want to change the order you have to delete and re-add them. If anyone knows of a better way, please let me know!
-
Is there a way to create a static temp table in Beast Modes?
I'm the MajorDomo for a large retailer, and our Fiscal Calendar uses a 4-4-5 format. This means we have a Week 53 this year, and a large portion of our Domo reports are built off of a TY/LY comparison. I'm working on logic to reconfigure our reports always look 364 days or 52 weeks ago, rather than look at the same Fiscal…
-
Hide/filter out cards on dashboard display
Hi, I was wondering if there was a way to hide cards from a dashboard under certain circumstances. For example if the data being filtered was a certain value, a specific card would disappear. This will be for clients to export dashboards to PPT and not need to clean up superfluous elements. In a similar vein, I'm also…
-
Filter a specific measure
Hi, say I am using a vertical group bar chat. For Y axis I want to show measure A (includes country A-Z) and Measure A with a specific filter say only country A, B, D. How should I go about it? as when I put country as the filtering, it just filters both bars
-
Page Level Date Filter nulling when not available in every dataset
I have a dashboard with cards running on multiple datasets (5+). To make date selection easier for users I've created a beastmode titled exactly the same across all datasets to show Q#-YYYY. There are instances where a there will be records of that date in some datasets and not others, the issue here is that I assumed as…
-
Dynamic Filtering of Page
Greetings Domo Community, I have been working to apply a dynamic (Beast Mode type) filter on a dataset that can then display a card. In simple terms, we would like to be able to filter a subset of a dataset, based on a defined algorithm that we implement on our card and then dynamically power cards using this subset…
-
Filtering table -- cells can have multiple values
I have a dataset table with filters. Some cells have multiple values. Say I have a column called "Device." Row 1 can have "Desktop, mobile" and Row 2 can have "Desktop." I want to have a filter called "Desktop" that shows all rows containing any instance of "Desktop." When I do the beast mode formula: case when `Device`…
-
Independent filtering within a dashboard, using the same column
Hi, I have a dashboard that tracks our current sales performance for the day with various comparisons, which works great. I've had a request to produce a version of this that would allow end users to select two dates, and then comparisons would run between these dates. I'd need to filter different cards, with different…
-
Filter to show blank cells?
Hey! I am looking to filter data to show columns that have empty cells. For example showing all results where 'Planning Condition Status' is blank. I had a look at doing a Beast mode formula but wasn't sure how to put 'Blank' in the formula? Is there an easier way for me to do this? Thankyou in advance.
-
Analyzer - Filters get rearranged alphabetized after saving.
Hello, I noticed recently that after I save a card and go back in the analyzer all the filters used to filter my data to build the card are getting rearranged alphabetized. I rearrange them and hit save..BOOM! rearranged again. This is not how it always has been and is becoming very annoying. Is there a new option that I…
-
Limit Date Selector Card for User Interaction
I have a dataset that has multiple report dates with each value summing up total for that day (each row has its own value to sum for the day). I have a date selector card as a calendar format but need to limit the user to only choosing one day at a time since choosing more than one will make the data inflated and not…