Filters

I have my dashboard set up so that the filter options displayed are modified by the value of the variable. EX: notice how the filter by time options change depending on the time frame adjuster value in the screenshots. This is the best way I have found to do it, but my employers find it still extremely unintuitive. I think…

Hi all, I am working in magic ETL and I have a dataset that gets appended each month. Most of the data is useless for what I am trying to use, except for the latest month's set of data. Is there a tile in Magic ETL that lets me filter out by latest date? I believe I could use a rank and order but am trying to not use…

When a PDP policy is implemented to a dashboard, I noticed that we cannot set the page filters (i.e. single select filter) to a default value for each PDP policy or have the page filter automatically set to a default value. This is because when there are mandatory dashboard filters in order for the dashboard to work…

Hi, I'm starting to play around with the App Studio. I was wondering if it would be a good way to have multiple dashboards within one place. Is it possible to persist filters across these pages within the app? For example, if I select a campaign ID in one dashboard, and then navigate to another dashboard within the app…

I woke up this morning and all of my embedded dashboards were broken. After some analysis it looks like any card on a federated dataset that is also using a filter is not rendering. These are embedded cards using programmatic filters below and none of them are currently rendering. They were all rendering properly…

We've included a "fuzzy filter" control/variable within our app, and upon selecting the input box, a list appears that worsens the UX (Mobile specific). The intention is to have, upon clicking into the input box, the user search up a name from the keyboard rather than through a list function, and then have this search…

We had a use case where a user wanted to select all options in a drop-down filter except for one. However, the drop-down filter tile does not have the option to select all (which is a bit strange as other filter options (i.e. check box, radio) have this feature). It is tedious to have to go through all the options to…

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.

Hi, I want to build a sales dashboard that allows me to cut the data by selecting the relevant data series from a slicer. example: Bar chart showing sales by month with various drill down options. Currently I will need to build 4 more charts that show the bars split down by each of, country, agent, Product, Channel.

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…

I would like to add to the date filters on the to right corner of charts the following options: Life to Date Last [X] [Period] to Date I have a dataset where a number exists for 'Max Business Date' each day. As the days pass, the number gets bigger until it reaches the total number of business days at the end of the month.…

This is a very minor inconvenience I face when trying to build a dashboard. The right borders of any filters I add to dashboards as cards seem to get clipped. Anyone else face this issue and know how to avoid it? The right edge next to the dropdown arrow in the filter is what I'm referring to

I have a card that uses variables to display info from different date ranges - some columns show metrics for a custom date range (defined by the variables) and other columns show metrics for the current month. When I add drilldown tables the date filters seem to get confused - it keeps picking the current day, even though…

I'm trying to create a dashboard filter view for a set of field values where some values are not in the current data set but could be in time. Right now, it seems I can only filter based on available data and not able to set up a filter for potential field values. Is there any simple way to establish these potential values…

As of right now the domo filter bar (screenshot below) allows you to natively filter a date through the menu to the right. Said filter,however, only affects cards within a dashboard and does not affect whatever dimension you are selecting from the bar itself. In the screenshot you can see a City dimension. That dimension…

I'd like to be able to apply different formatting to the values in a Quick Filter list, just like I can change them in the visualization. Example use case: my report users are in Europe, so they use date format MM/DD/YYYY. The dataset date values are in DD/MM/YYYY. I can easily update this in a visualization, but the Quick…

Hi, Can I use SubDate to filter a dataset within Magic ETL? We import our leadership team monthly. However, there are certain reports where I need the end of quarter leadership team instead of the most recent leadership team. Right now, I have the quarter end date hardcoded, but I would like to have a dynamic function.…

Hi, Can we implement a Reset all filters(global & custom) whenever user selects OptionB from OptionA in the variable selector? Variable selector values: Option A, Option B. Global Filters: Geo, Region, Type, Mode. Thanks in advance :)

I'd like to be able to type in a list of filter values for a card, regardless of whether the values appear in the data set. Use case: records can be in one of several states. I want to include 3 of them in my Card. However, there aren't always records in each of the 3 states, so I can only set my card to include whichever…

I need help to create an interactive calendar filter. I have 4 filters: Fiscal year, Fiscal quarter, Fiscal month and wanted to add a calendar for the custom range which is interactive with other filters: The problem is that when I select the fiscals, the calendar is not changing base on the selection: Based on above…

Hi all About to through my Mac through the window if I can't sort this. How do I write a Beast Mode that sums data whilst ignoring ALL filters? Many thanks

Same functionality that exists in classic dashboard cards. These icons obscure the view of the card by putting a small blue 'filter' icon over the bottom left of the card when a filter is selected.

Hi, We have an invisible brick inside a page embed. It's only job so far is to notify the host through a postMessage when a filter has been applied ( using domo.onFiltersUpdate() ). The host then listens for this postMessage and stores the chosen filters in session storage. This is all working well. When the modal is…

The options I have are % of total and % of category, neither which work for this. How do I show % of year?

I have a single table that some columns or calculations use one date field and other columns use another date field. However domo only allows you to associate a single date field to the entire chart/table. This is extremely frustrating. For example the red columns use TransactionDate but the green columns use…

Is there a way to create a filter in a dashboard includes only the selected value in a card and includes everything else but this filtered value in another card? for example, if I have 10 ids, one card should have the sales amount for the specific ID I'm filtering on and another card should have average sales of the 9…

Hello Folks, I understand we can do comparison in terms of YoY, MoM, Last year etc on a graph chart. But can I have those calc as Filters on the dashboard? Please guide me, Also can we add any other customer filters specific to scenario? TIA.

In DOMO, there is an option to remove "Allow adding of new filters" for a Dashboard, but this removal only removes the ability for the Participant to save filters for all who access the card. I was interested in not allowing the Participant to save a filter at all and that is currently not an option. I am proposing to have…

I have a dataset that is aggregated by a calendar week number. How could I ensure that when a user goes to view a respective card, that they see the most recent week (even if the dataset hasn't updated in 2 or 3 weeks?) i.e. the user views the card in week 15 but the dataset hasn't updated since week 13. So I would want…