-
Modify the filter column values while drill down
Team, I have created the drill down using 2 different datasets and 2 table cards. While drill down, drill path filter should always consider the default column and pass the value of it to next level. thanks M. Vijay Antony
-
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?
-
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
-
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…
-
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…
-
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,…
-
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…
-
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…
-
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