-
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…
-
App Studio Controls/Filters
While creating apps with multiple pages/tabs we don't often use the same dataset for each card we put on a dashboard (app in this case, woohoo for app studio!) Where we are running into trouble here is that page filters only have the option to select a singular dataset rather than all datasets where the field is present.…
-
Domo Office Add-In - Relative Date Filters
Hi, the legacy version of the plug-in that our users are widely used to had the ability to do relative date filtering. Unfortunately, the new version does not include this functionality and is hindering our effort to get users to upgrade. Please enhance the new add-in by adding relative date filtering.
-
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…
-
Radio Button Filter Card - Set the default selection?
Hello, I have a Radio Button Filter Card on my page. I'd like a default value to be selected on this card. However, I can't seem to find a property that enables that. When i use Page filters to set a default selection the user can clear the filter, or filter on multiple values (which defeats the purpose of the Radio Button…
-
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.
-
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?
-
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?
-
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..…
-
Filtering on Null Values
I have seen this question/idea opened and closed several times but I will submit again that a user being able to include or not include null values with a simple filter is important. I understand the ETL and beastmode workarounds but it is not scalable to have every request run through a limited data team just to find out…
-
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:…
-
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 :(
-
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…
-
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!
-
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?