-
Filtering strings that contain letters
I want to filter out strings that contain letters in my ETL. e.g. Serial 112233 445566PN In the ETL Add Formula Column Name: IsInt CASE WHEN serialLIKE ('%[A-Z]%') THEN 0 ELSE 1 END EDIT CASE WHEN SERIAL~* ([a-z]) THEN 0 ELSE 1 END This is working for A-Z and is case insensitive. Next question, is how do I filter out other…
-
Passing filter from Parent Page to Child page - Global Filter
In domo we need to an option to pass our Parent page filter to child page.
-
App Studio: Integer Filters need RANGE
Please let us see the min/max/avg range for numerical filters on the App Studio control panel, like we do in Analyzer and on regular card filters: Needs to show this VERY important column-level metadata: The lack of range could cause a user to misinterpret how the data is aggregated.
-
Allow sorting of quick filters
Currently, we have many academic years in some reports but usually need to sort by the newest. However, all the order academic years are at the top of the filter and we need to scroll down the filter to get the current year. Having the ability to sort this so the data currently on the bottom would be on the top would be…
-
Applying Filter Tile to Remove Nulls Not Working
Any ideas as to why this isn't happening?
-
Waterfall Chart that allows for intermediate results
Hi, we are currently not able to built a waterfall with intermediate results using the waterfall chart in domo. It is somehow possible with a workaround using the bar chart to create bars that reflect an intermediate result step. This would be super useful, since for now we are opting out for other solution that are more…
-
Remove character limit on filters
We have many dashboards displaying survey data, which include a lot of open-ended responses/long text comments. Our sales staff need to be able to filter to a specific partner's survey responses, and select specific comments for inclusion in an exported report for the partner. Currently, I have these text responses set up…
-
Accounts with Profit Sharing Formula and Filter
Hello, We've got some customers that have profit sharing rules in place. As my data comes over it doesn't take this into account so it shows full profit attributed to us. I'd like to have a filter to toggle profit sharing on or off to show either full profit or the profit taking into account the sharing. If, for example, I…
-
Freeze top cards (Filter Cards) on a dashboard
I have multiple dashboards where I have filter cards at the top. When I scroll down the filters disappear. I'd like to be able to move down to different sections of a Dashboard and be able to still see the filter cards and be able to change the filters and still stay at the current position (card) in the dashboard.
-
AND filters in dashbaords
When we use a filter to select multiple values in a dashboard it uses an OR statement. For example : If I want to see all orders containing SKU A and SKU B, how can I achieve that with a filter on a Domo dashboard? Typically, it only provides orders containing SKU A or SKU B. Hence, I'm curious if there's any method to…
-
Duplicate filtering status to top right of card
Currently the filtering status appears at the bottom right of cards. When you have cards that are quite tall it would be good to have the filtering duplicated to the top right of the card as well so it is obvious to the user that the card has finished filtering.
-
Have a row displayed with 0/NULL when filtering by date when there's no data
Tried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting the data into a Pivot table and have campaigns as a Row. I'd like to have every campaign show in the table even when it has no data to report for the selected time frame. It essentially would the the row for the campaign and…
-
How do I filter by most recent date?
We have a dataset that get multiple 'loan_id' entries recorded (shown below) However, when I go to remove duplicates on any of the columns, I generally get the wrong loan amounts. The correct loan amounts are always the ones with the latest 'time_stamp' I am hoping to remove any duplicate 'loan_id' based off the latest…
-
Drill down to zip code map not filtering to rest of dash
Hi All, I've successfully created a drill down U.S. map card that takes you to zip code level. However, when zip code is clicked the rest of the dash is not updating. But when I click other cards on dash the drill down U.S. map is being filtered. What am I doing wrong?
-
What is the best way to filter open-ended comments on a dashboard displaying survey results?
We have several dashboards that we've built to review customer survey data. We always have several open-ended questions/comment boxes on these surveys, with thousands of responses. Currently, I have these text responses set up as drop-down selector filter cards, which then populate table cards that are used in dashboard…
-
Dashboard Filters - Way to only show the 'Choose Date' filter?
Hi all, Is there anyway to show only the "Choose Date" filter on a dashboard, while keeping all other page filters hidden? I am creating a dashboard with some DDX customizations, I have a custom set of filter dropdowns to streamline and speed up dashboard use within one of these bricks. I want to hide the non-date filters…
-
I am trying embed a dashboard and apply filters using the pfilter param and it is not working
Currently I am having issues getting the pfilter query param with the embed working in an iframe. I have followed many of the examples out there and have replaced every special character in the value with their ascii counter parts but nothing has seemed to work Here is an example of what I have been trying:…
-
Domo Embed - reporting with a date range issue
I have an embedded dashboard that has programmatic filtering which includes a date range. This functions fine although i am now hitting a challenge in testing for the following reasons. I have records in the db table for when a product is available and another date for when its not available. I want a count of records that…
-
Using pfilters with more than one value
Hi, we have this dashboard with several card filters and we want to click in one "button" that would open the same dashboard with all the filters applied. We know that this is able to do it easily by creating a BeastMode with pfilters as shown here and in the @MarkSnodgrass video. However, we are not able to find a way to…
-
Date Reference Exclusion/Inclusion
I'm attempting to write a beast mode that checks a static date with a dynamic minimum date. If the static date is greater than the dynamic minimum date it would be classified as 'No' and vise versa. The beast mode formula: CASE WHEN Onboarding Date <= (MIN(MIN(Report_Date)) OVER()) THEN 'Yes' ELSE 'No' END When I use the…
-
A filter based on weekday or wknd
I have a column with tasks and there are certain tasks I want to see if the current day is a weekday and if the current day is a weekend day id like to see other tasks. Could someone help me with this?
-
range filter card should function the same as quick filter
I would like to see this filter card: Have the same kind of display as the quick filter for a range: The dropdown allows for more control, and the ability to type your number in the box rather than move a sensitive slider is really ideal.
-
Card switching using a filter/control in a dashboard
It would be great if there's a way to swap different cards using a filter/control (If I choose category 'A', I want a certain card to be visible and if I choose a category 'B' I want a different card to be visible. (Essentially looking for Domo equivalent of sheet swapping with a parameter in Tableau)
-
Early noob questions and frustrations around filters in analyzer
I'm experimenting with Domo and I'm trying to recreate some powerBi reports. I have successfully connected to our Jira instance for issues and I'm now trying to create some visuals and reports based on the "issues" database. One of the charts I'm trying to build requires me to filter based on a date field containing a…
-
Filter behavior on dashboard/app vs Details View
I wish the default behavior for filtering via-the-legend at the dashboard/app level would mimic what happens when viewing a card in full screen/via the details view. When I click a colored block in a legend, I'm intending to remove that color from my view and allow the chart to re-scale. I think it's confusing that this…
-
Date Selector Filter - settings
I would love to see an enhancement to chart properties on Date Selector, specifically for the PRESETS menu. Our data is not live, it runs nightly. So any filter for "TODAY" will always yield no results. The Chart Properties > Presets View has options to exclude Week, Month, and Year options - please add the option to hide…
-
Date filter
I have data that has reporting data for every day. I need help creating a quick filter on dashboard when i select it and see last 7 days
-
Discrepancy in Filter Responsiveness Across Charts in DOMO Dashboard
Hello everyone, In our DOMO dashboard, which comprises seven charts, we observe that five of these charts appropriately respond to the global 'Businessunit' filter. However, there are two charts that, despite containing the 'Businessunit' field, do not align with the dashboard's overall 'Businessunit' filter settings. This…
-
Date Filter in Embedded Dashboards
The date filter in DOMO's native site is very powerful. I can group date variables by day, week, month, filter on Between dates, a single date, last month, year…etc. However, when I embed a dashboard, all of that capability goes away and I have to create filter cards which are cumbersome and not nearly as dynamic. Please…