-
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,…
-
forcing x-axis in bar chart to ignore filters
Hi all I have 30-40,000 rows of data presented to a bar chart with 5 dashboard filters operating across the data. There are 15 different categories presented as the x-axis. Occassionaly filtering removes one of these categories. I'm trying to find a way to leave the category on the x-axis despite the fact that it is no…
-
OR Filter Capabilities on Dashboards
Ability to define more customized filtering logic to define OR and AND in grouped ways across filters.
-
Beast Mode Calculation used to view data in Table
My question is related to showing Comments/ Verbatim in a Table using a Beast Mode to Apply Business Rule. In Org Survey, we want to make sure that if we have less than 5 unique comments then don't show the comments. If the Business Rule of >= 5 comment is met, only then show the comments/verbatim. Below is an example…
-
Dashboard Default Filter View not shown with Scheduled Report
We'd like to include the default Filter View of a dashboard when scheduling the page as a report, so that the primary column filters are available as shown in the screen capture below. However, when someone clicks on the received email they see the Close Report / Save Filters to Report options and the default filters are…
-
Filtering Question
I have a mega table report that is displaying customer invoice data. One of my filters is for the Aging Range. I have been asked to modify the filter to include all invoices for a customer if any of their invoices are in the filtered range. Meaning that in the below dataset if they selected to filter 151-180 all invoices…
-
Office 365 PPT Plugin - Can't use Beast Modes as filters
Hi everyone, I was just wondering, do you know how to use beast modes as filters on the new O365 plugin? I only see the fields that are coming directly from the datasets as filters, but can't see beast modes. Thanks!
-
Require filter selections
DOMO should really consider adding a feature to require an option selection by the user when a developer configures a page filter card. This would coerce the underlying dataset to subsetted in order to prevent double counting in some cases.