-
Filtering on missing / null values is awful - improve it!
TLDR: If a column contains a null value, there is no way built into the UI to filter to select null values only. Additionally, if you happen to choose "NOT IN" as your filter type and select a value, NULL values will additionally be excluded even if not requested. I understand that there is a workaround using beastmodes,…
-
Smart Text with many filters selected, best way to represent it for better users experience?
Almost every time I build an App, there are multiple filters to select up top (Name, Branch, Province, Branch type, etc.) I usually have a smart text to show the selected filters for approriate section. However, the smart text look very busy when you have more than 3 filters selected: Another option is to break 1 line to…
-
Autogenerate Filtered Page Deep Link
It'd be nice if it was able to automatically generate the pfilter deep link for the current existing filters applied to the page to more easily share the exact same page view for other users and to save time and difficulty if we're wanting to do deep linking from another card to this new page.
-
Allow Dynamic, Rolling Between Date Filtering in Charts
Idea: Allow either the 'between' date range filter for charts to also allow selection of 'X months ago' to '2 months ago' (see second screenshot for current version), or have the 'Last' filter allow an "Exclude" last 'X" months option. (see first screenshot below) Problem: Needing to do date centered visualizations with…
-
APP PDP Policy View
I am trying to figure out if there is a way to be able to view an app from different PDP policies, I am the admin and I am trying to build out apps for people but want to be able to test and see what others are seeing based on their PDP
-
Organizing Global Filters in Apps
We would like the ability to organize global filters in Apps. We create global filters for our most used filters for clients but we aren't able to organize the filters in a logical way. The filters appear in the order of selection when setting up the global filter, but it would be helpful if they were alphabetized or you…
-
Export Filtered Results
{I think we already posted this request but I don't see it.} When I filter a dataset and export, the export contains all the data and all the fields. I want export to only export what is displayed. If a filter is active, the export should only contains records that match the filter. I keep having to create cards just to…
-
Calendar date to be aligned with other filters
we have seen an issue when we created date filters, Date calendar is not cooperating. The expectation is that when a stakeholder select the fiscal year and month the calendar date is showing the chased month, not the current month
-
DDX Brick: Page Filter
Hi Everyone, I have created a DDX brick which is correctly making a gauge chart however it only shows the total aggregated number and doesn't update when a page filter is applied. Does anyone know what further code needs to be applied? I want it to update when the column DATE is applied on the page. Thank you for your help!
-
Allow filtering alerts ‘Subscribed to by’ a group. Currently, only users can be filtered
To date, it is not possible to filter alerts when they are shared with a group, because groups are not displayed in the drop-down menu of ‘Subscribed to by’. This should be improved and groups should also be displayed
-
Bar Chart Selection Not Filtering Data Card
Hoping someone can help me on this one. I've got a dashboard (below) where I have two charts, one that looks at data across all time, then one to its right that focuses on last 4 weeks. Then I have a detail table below to show results. When the right weekly chart has results that display at least 2 bars, either bar becomes…
-
Bar Chart Selection Not Filtering Data Card
Hoping someone can help me on this one. I've got a dashboard (below) where I have two charts, one that looks at data across all time, then one to its right that focuses on last 4 weeks. Then I have a detail table below to show results. When the right weekly chart has results that display at least 2 bars, either bar becomes…
-
Filtering and Adjusting Cross-Month Records in MagicETL
Hey Domo Dojo Community, I'm working with a dataset containing reservation start (RSD) and end (RED) dates in the format of MM/DD/YYYY. I need to identify all records where the reservation spans across two different months (i.e., RSD and RED fall in different months or years). My objective is to filter out these…
-
Better date selectors on cards
I'm surprised that the date filters available on cards aren't as dynamic as the global date filter. For example, I'd really like to be able to have something like this on a card: In comparison, the 'Date Selector' card only gives presets, and using the 'Range selector' is not the best when filtering specific dates!…
-
MTD, MTD Last Year Beastmodes do not work properly with Date filter
I created 2 Beastmodes that I can drag into the 'Values' in the Pivot Table card: MTD = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) THEN IFNULL(Amount * -1, 0) ELSE 0 END) MTD Last Year = SUM(CASE WHEN Month = MONTH(CURRENT_DATE()) AND Year = YEAR(CURRENT_DATE()) - 1 THEN IFNULL(Amount * -1,…
-
Page filter add contains + allows "ORs"
When using a filter on card on a text field, you can use a contains "blah" as a condition. Great.. But then when you go to a Page filter, you can only select literal values (I know you can search and click "all" to get a similar result but it's not the same thing). I would like to be able to do this in a page filter too..…
-
Filter does not work on all cards in an App
So I have Dataset A which contains 'Customer' and 'Account Number' columns, I created a Beast Mode 'id & customer name' = CONCAT('Account Number, ' ', 'Customer') then use that Beast Mode to create a selection drop down filter card called 'Customer'→ add that to an App I have a dataflow that is just an unpivot of the…
-
When clicking to filter, shouldn't the default be to INCLUDE the value???
Let's say I want to filter the page for the owner changes. Since the slices get small, I have to use the legend to do that. It excludes the values instead of filtering. For extra fun, it also makes the page filter 'In' all the other values! I am also providing an example, using a bar chart, since we would so clearly want…
-
Read pfilters in DDX Brick
We have created APP in DOMO and we are using pfilters to load the dashboard as per filters passed like we are passing client id, date range. We had to create DDX Brick as we wanted some custom logic for one card so DOMO suggested to use DDX bricks. We have created a DDX Brick and added card in APP for this Brick.…
-
Customize Control/Filter options in App Studio
Is there a way to customize the control section in app studio so that users cannot click '+Add Filter' and see all columns from all data sets as filter options? I want to limit their filtering options to just 5 specific columns
-
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…
-
SELECT ALL in dropdown filter
we are missing the select all option in dropdown, so if I have 20 items and I want to select 19 I would need to do it manually :(
-
Sharing Filter Views despite dashboard page lock
We have a highly viewed dashboard that we have locked so that people can't change. People want to create filter views and then share them with other people. Unless you are an admin or have the grant of "Manage all cards and pages" (which is a security liability) then they can't share it. Therefore, I propose: The ability…
-
Allow NOT IN option on dropdown filter cards
Chart Properties for a filter card allow for a few controls (multiple selections was a big win, thank you) However, it does not allow us to show an In/Out filter, which is default feature on page filters. If I add a dropdown filter card in App Studio, we can use it for "include" but not "exclude". The control panel is…
-
Individual Default Filter View
It would be nice to allow individuals to set their own default filter views. Right now, the only way to set default filter views is to set it as a default for everyone. It would be nice to allow people to select their own, if there's a certain view that they always use, so they don't have to go through the dropdown every…
-
Filter Request from Custom Domo App
Hi everyone, I am currently working on a custom Domo app using React, and I'm trying to develop an interactive filter app. I've researched the domo.js library and found that it mainly provides functionality for managing and operating datasets, users, groups, etc., in Domo. However, it doesn't seem to be suited for sending…
-
Month filter not working on all cards in an App?
I have 2 card visuals for my app right now. Card #1use dataset 1 (have a month and a year column). Card #2 use dataset 2 (which has a date column, formatted as 'yyyy-mm-dd' And so my goal is to select a Month (say August), and both card #1 and #2 would show the data only for August. But if I create a "Dropdown Selector"…
-
Create a "Latest Available Date" selection for page level and card level filters.
I know I can do a max (`datefield`) over () in a beastmode, but this only works for card level filtering and not page level filtering due to the fact that this is an aggregation beast mode. For the page level, it requires a rank and window in a dataflow. Both of these work arounds break any smart text that would refer to…
-
Dropdown Selector: always have pre-selected the latest date on a filter card.
Hi, I have a filter card (dropdown selector) to display all dates available and I would like to have pre-selected the latest date. Is this possible? Right now I added it by manually typing the latest month but I'd like it to switch automatically when the month ends. Any ideas are welcome! Thanks
-
Default Values on Filter Cards
It would be a huge QOL improvement for our company if filter cards could have a default value selected (the most recent date, the first value in ascending order, all values that equal a specific string, etc.) because many of our dashboards need to have a single filter value selected to display accurate data. For example,…