-
Key Word Search - Filter Card
Create the ability to do a Key Word Search across all columns used in a table card. Create a filter card for easy access. This is currently possible by creating a beast mode and concatenating all used columns and adding filter for this new field. However, it's not user friendly as the search results display the full…
-
Filters not working
I woke up this morning to a lot of emails about filters on multiple dashboards not working. I firgured out that the ones that weren't showing all the available options (broken) were filters that didn't have anything in the "Optional Group By" tab. Was there a new patch pushed out by DOMO that makes you put something in the…
-
Color rules not working with bar + line chart
I have a bar + line chart where I am using partner_name dimension (blue) in the SERIES field along with another numerical metric (green) as shown below Despite applying color rules on the partner_name field in the card, I am not seeing the color change when I change the filter values for this field in the dashboard. But…
-
How to build filters with images or icons
A Domo user was recently having a hard time figuring out how to incorporate images and icons into her filters. Here are a couple of awesome videos that helped her solve her problem. Hopefully, this can help anyone who runs into a similar issue in the future!
-
Transforming Support Staff Name Column
Hello, ETL question. For context, I am creating a dashboard for self-service reports on customer satisfaction surveys. Typically I would create a drop down filter card to 'Filter by: Owner', but in this case the owner column contains multiple names: IE: Owner Joe Smith, Bob Smith Cate Smith Cindy Smith, Sam Smith Does…
-
Please help me write this filter formula:
How can I write a filter formula where I want to exclude everything that says 'INTERCOMPANY' from 'CUSTOMER TYPE' Column except this one scenario where we keep 'INTERCOMPANY' where there shows 'X' in 'COMPANY' Column. Similarly, how to write a filter formula where I can exclude everything that says 'ENDUSER' from 'CUSTOMER…
-
Dynamic Filtering based on user permissions
I am trying to write some PDP policies. An example use case of my problem is that, all the users in my application have access to school names. Some users have access to multiple schools, while others have access to 1-2 schools. The schools these users have access to are defined on my backend. My DOMO dashbaord has a…
-
Programmatic Filters Implementation Help
Hi, I'm using programmatic filters for the first time. This image below is on Domo's documentation - . I created a similar file in my code base but I'm not sure what visualization1 is? Is it the name of the dashbord? Where is it defined? Additionally, how is this called in the frontend? Do I need to do anything on the…
-
Period over Period Visual, YTD, 2 Day Delay with Current Date Data
Hi all, I'm leveraging the period over period charts and comparing the year to date progress with the progress from a year ago. Unfortunately, there's a two day delay in when the data comes in, and the historical period data isn't reacting to that. Is there a way to address that while still using the period over period…
-
Controlling List of Possible Filter Options
Overall, users should have the capability to manage what metrics and columns show up when filtering across an entire page or dashboard. The ability to filter a page on anything in the underlying dataset is great. However, through working with category managers I've found that this results in there being too many things to…
-
Is it possible to retrieve Variables when using Bricks?
Brand new to Bricks here. If we add a variable to a dashboard that should change the behavior of all cards including a brick, can we check the value for that variable in the Javascript section to so we can adjust our query or logic accordingly? I saw in this video that you can add controls to the brick itself, but was…
-
Filtering Records Based on Aggregate Criteria
I've been trying to do the following but can't figure out the best way to do it. I have a table that looks basically like this: user_id|ticket_id|inquiry_type I want to filter out rows for a specific user_id when ALL of the rows for that user_id have a value of "false_inquiry" in the inquiry_type field. But if the user has…
-
Is there any chance to disable filter view on drill down chart?
I was able to disable filter view on a primary card but global dashboard cards are showing once chart drill down. Any posibility to disable this view?
-
Beast mode to select all the slicers
I have a column that populates the below 7 options, I would want to have another option 'All' which displays numbers of all 7 cases instead of manually selecting all 7. I am trying to write a below beast mode for the same but the 'All' option would not include all of the cases. case when combination = 'desktop' then…
-
Disable slicers from being displayed as filters on top of the dashboard
Hi, I am using slicers in the dashboard but since the page is too long, I plan to duplicate these slicers and use them in the 2nd half of the page as well. However, I do not want to display these slicers on the top of the page as filters. Is there a way to disable the filtered view for slicers?
-
Antithesis Filtering on Dashboard
Hi all, When filtering on a dashboard - traditionally, my process is to have a few filters at the top of the dashboard, which are my top-level generic page filters. This process works great for me, and it's standard across our dashboard offerings that our audience understands. I've now started building a dashboard where I…
-
Using date filter as input for Beastmode calculated field
Hi, I have a Beast mode calculated field where I use MAX('Sales_Date') to keep the calculations fresh automatically (as we are getting the data with 1-2 months lag so I can't use current date). Problem is when users start changing the date range filter in the dashboard to a range not including the MAX('Sales_Date') in the…
-
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…