-
Filter visualization on dashboard help
I have a dashboard that I added a donut filter to at the top containing Category A and Category B. Below it, I have a single bar chart with no series that shows the amount of new paid companies in a given week. At the bottom of the dashboard, I have a standard table with the complete list of companies. The intended…
-
Force a filter selection on filter card
I need (and have often needed) a way to force a selection on a filter card for a dashboard. I know I can set default values, but I need a way to ensure at least one selection is always made. Anyone found a workaround here?
-
Distinguish interactive filtering from hover values
Create an out-of-the-box setting to specifically separate interactive filtering from hover values when embedding a dashboard or card
-
Any way to filter a column by data type?
I am working with a data set that has multiple contributors. Unfortunately many of them enter data their own way. Specifically, I am looking at Diabetic A1C data. One person might enter it is as 5.765, another 5.76%, yet another 5.764444E3, and then another would enter something as 93 MG/L. Is there any formula or DOMO…
-
Change Column Name Based on a Date Selected in Drop-Down Filter
Do you know if it is possible to change a column name or add the date to an existing column name based on the date filter selected. Example: If the column name is Actual Monthly and I select a reporting period filter of 09-30-2024, is there a way to have the date populate in the column name on the fly?
-
Editor Access to Share Filter Views (Without having access to manage or delete cards/pages)
Background: 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. As part of our data security measures, we only allow our Admins the privilege to own pages and manage…
-
Filter card always have a value selected?
I have a beastmode called 'Flagged' (value 1 and 0), and I use the BeastMode to create a filter card and then add that filter card to an App. Is there anyway to have 1 or the 2 value always selected? So it's kinda force the users to always select 1 of the 2 options
-
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…
-
Filter using multiple date fields
Hi there, I have created 5 calculated columns in DOMO analyser that get me the max date in each of the fields (Let's call them- Reconsideration date, Complied Date, Status last updated date, Appeal date and Death Penalty Date). They are all derived from a number of different fields with different conditions and then I…
-
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 :(