-
Can I filter by latest date?
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…
-
Dashboard Page Filter: Automatically set a default value based on the available values in the filter
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…
-
Filter persistence between pages within App Studio
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…
-
All cards using federated data sets and using filters are broken
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…
-
Option to Toggle List Drop Down in Search
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…
-
Add "Select All" Option To Drop-Down Filter Card
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…
-
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.
-
Toggle Series through a filter
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.
-
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…
-
Last X Periods to Date
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.…
-
Edge of filters getting clipped in Domo
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
-
Drilldown tables on cards displaying info from multiple dates
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…
-
Filtering Against "Potential" Field Values
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…
-
Improved filter interactions
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…
-
Formatting for Quick Filter Values
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…
-
SUBDate As Filter?
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.…
-
Reset filters on action or event
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 :)
-
Enter list of filters independent of values in data set
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…
-
Interactive Calendar Filter
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…
-
SUM('Revenue') BUT IGNORE ALL FILTERS PLEASE!!!
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
-
App Studio: Ability to remove filter icons from cards
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.
-
access page embed applied filters in brick to pre-select filters
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…
-
I want to show % of year...how do I do that?
The options I have are % of total and % of category, neither which work for this. How do I show % of year?
-
Assign date range field on a per column basis
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…
-
IN vs Not IN two different cards
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…
-
Custom Filters - YoY, MoM, Last Year
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.
-
Option to Remove Participant Filter
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…
-
Ability to sort Filter Views
Filter views are a very powerful way to quickly filter data down to what you want to view on a page without having to set the filter each time. Problem: These views are currently stuck being in the order in which they were created. If they are needed in a specific order, they have to be remade to be in the desired order.…
-
How to apply filter to card that is always showing the most recent dataset update?
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…
-
Filtering data with 2 columns with beast mode?
Now I have a dataset something as below; ID Cat Name Cond01 0001 1 A 3 0002 2 B 4 0002 1 A 3 0001 1 D 1 0003 2 B 7 0003 1 C 5 0004 1 A 9 … … … … Now I want to make two filter cards to select data by Name , conditioned with a Cat value, where one card is for filtering data by Name when Cat = 1, another one by Name when Cat…