-
Antithesis Filter Interaction
Hi, There could be great value in the simple addition of a new option in a specific card's, "Filter Interactions", where instead of filtering on x in a dashboard filter (Number of Apples in a Fruit bowl), specified cards could filter on the antithesis (not x) of the filter (Number of not Apples in a Fruit bowl) This…
-
Checkbox Selector not showing all values?
Good morning, While trying to create a Checkbox Selector to use as a filter, I've run into an issue where the card is only showing some values instead of them all. It's not even a massive data set; it's 15 values. However, when creating the card I see the dreaded "Warning: Not all data is shown" message (14 of the 15 are…
-
Ability to Set Default Value for Filter Chart Types
It would be ideal to be able to set default values for filter chart types, especially the date selector and radio button filters. I have seen multiple posts mentioning that this is available for beta. Is there a timeline as to when this will be available to the masses?
-
Filtering data will completely remove blank values
Hi community, I'm not sure if this is by design or if this is a bug. Filtering data within a field will completely filter out the blank values as well. It looks like Domo won't recognize the Blanks as a value. This is an scenario: FieldA, FieldB CategoryA,12345 CategoryB,58679 ,89658 CategoryD,97865 CategoryY,74935 Filter:…
-
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.
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
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…
-
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…
-
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…