-
Can you remove filtering capabilities for specific card level for Participants?
I don't want to remove ALL filtering ability for participant-level users, but there are certain instances where that would be ideal. Is that possible?
-
Is there a way to use a matching value filter with a single select filter?
Hello! Currently, the filter control options avaiable for Quick Filter are: Match value Single select Multi-select Is there a way to use these filter controls together? For example, I may have two columns with the following values: Name Pets Ann Cat, Dog, Bird, Reptile Ben Dog, Bird Kate Bird, Reptile Tom Cat Will Cat,…
-
Can I use a filter to make a filter?
I have a dataset that is a schedule of products to promote. A different product is promoted every day and we don't want to promote the same product more than once per month, at least. I want to be able to look at my schedule (just a table in Domo) and only see products that I have not promoted over the last 4 weeks, 5…
-
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…
-
Allow sorting of quick filters
Currently, we have many academic years in some reports but usually need to sort by the newest. However, all the order academic years are at the top of the filter and we need to scroll down the filter to get the current year. Having the ability to sort this so the data currently on the bottom would be on the top would be…
-
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…
-
Saving filters
We are embedding our dashboards within our products via an iFrame. The issue we are having is saving the filters that a user has applied to their dashboard. Is there a way to save this in some sort of json string so that we can reapply it when that user logs back in? Programmatic filtering seems to limit the overall…
-
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…
-
Export Data Option - Exports WITH Selected Filters
Currently if you are filtering on a dataset and want to export the dataset based on the filters, I don't believe this is not possible unless you create a card with filters or an ETL. I would like the option to export the data with the filters applied on the dataset view.
-
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…