-
Filter a specific measure
Hi, say I am using a vertical group bar chat. For Y axis I want to show measure A (includes country A-Z) and Measure A with a specific filter say only country A, B, D. How should I go about it? as when I put country as the filtering, it just filters both bars
-
Page Level Date Filter nulling when not available in every dataset
I have a dashboard with cards running on multiple datasets (5+). To make date selection easier for users I've created a beastmode titled exactly the same across all datasets to show Q#-YYYY. There are instances where a there will be records of that date in some datasets and not others, the issue here is that I assumed as…
-
Dynamic Filtering of Page
Greetings Domo Community, I have been working to apply a dynamic (Beast Mode type) filter on a dataset that can then display a card. In simple terms, we would like to be able to filter a subset of a dataset, based on a defined algorithm that we implement on our card and then dynamically power cards using this subset…
-
Filtering table -- cells can have multiple values
I have a dataset table with filters. Some cells have multiple values. Say I have a column called "Device." Row 1 can have "Desktop, mobile" and Row 2 can have "Desktop." I want to have a filter called "Desktop" that shows all rows containing any instance of "Desktop." When I do the beast mode formula: case when `Device`…
-
Independent filtering within a dashboard, using the same column
Hi, I have a dashboard that tracks our current sales performance for the day with various comparisons, which works great. I've had a request to produce a version of this that would allow end users to select two dates, and then comparisons would run between these dates. I'd need to filter different cards, with different…
-
Filter to show blank cells?
Hey! I am looking to filter data to show columns that have empty cells. For example showing all results where 'Planning Condition Status' is blank. I had a look at doing a Beast mode formula but wasn't sure how to put 'Blank' in the formula? Is there an easier way for me to do this? Thankyou in advance.
-
Analyzer - Filters get rearranged alphabetized after saving.
Hello, I noticed recently that after I save a card and go back in the analyzer all the filters used to filter my data to build the card are getting rearranged alphabetized. I rearrange them and hit save..BOOM! rearranged again. This is not how it always has been and is becoming very annoying. Is there a new option that I…
-
Limit Date Selector Card for User Interaction
I have a dataset that has multiple report dates with each value summing up total for that day (each row has its own value to sum for the day). I have a date selector card as a calendar format but need to limit the user to only choosing one day at a time since choosing more than one will make the data inflated and not…
-
DDX ECharts Area Chart App - Page Filter
Can the DDX ECharts Area Chart App be filtered using the page filters?
-
Dashboard Filters
Hi Guys, When I filter the date range by week I am getting the week of 05/27/2022 to appear on my card, but I am not getting the June of 2022 or the year of 2022 when I try different ranges. CASE when MIN(`Period_End_Date`)=MAX(`Period_End_Date`) then DATE_FORMAT(`Period_End_Date`,'Week of %b %d, %Y','month of %b %d, %Y')…
-
Layer multiple filter views on dashboard?
I have defined a set of filter views based on geographic location, and another set based on channel. Currently, it is only possible to filter on one dimension or the other. Is there a good way to build a dashboard such that I can simultaneously filter the data on the cards across multiple dimensions?
-
How do I force a Filter to have a value?
I have a dataset that looks something like this: I want to build a card that shows the Q over Q difference and allow the user to filter by Region. But I also need to either have the filter always have a value, i.e., not allow the user to unselect all values, or show the difference between the 'Global' values when none of…
-
Take large text input as field for filtering?
I have a slicer card to filter zip codes for a large data set. There is a search bar field for finding zip codes to filter by, but say I had a large list/string of zip codes and I wanted to select all of them for filtering. Is there a way to paste this list into a search field to filter them all, instead of selecting each…
-
Drill Path Filter to show Specific Apt's without a Specific Procedure
Hey guys, I'm worried that the answer to my question is that it has to be done in ETL, but I'm hoping it can be done as a beast mode. So the data in question looks similar to what I have below: Doctor | Procedure | Date | Apt # | Patient Dr. B | D0330 | 4/1/22 | 80136 | I. M. Madeup Dr. B | D0126 | 4/1/22 | 80136 | I. M.…
-
Looking up values from secondary data source but for multiple columns in primary data source
So I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I have a primary data source with multiple columns where values are stored in shorthand like "hc_res" but I want to display reports with pretty names like "Healthcare Resources". The mapping of "hc_res" to "Healthcare Resource"…
-
How can i write this sql statement in domo?
where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '2020-07-01') Statement below is a column I use for an sql query.. ROW_NUMBER() over(partition by a.Customer order by MIN(a.InvoiceDate)) as OrderNum I am getting an error while trying to convert this statement. I am not sure how to…
-
How to create separate filter sets in one dashboard?
I am creating a dashboard that will be divided into two sections and I would like to add separate filters to each section. I can't figure out a way to do this =/ Thank you in advance for your help!
-
Filter a DataSet with values from a Google Sheet?
Hello, I have a dataset that I would like to be able to dynamically filter based on values in a Google Sheet. This feels like a fairly simple MagicETL to me but I'm stumped at the moment. In short, the PROD dataset is good to go and I would ideally be filtering one column from the PROD set based on values in one column in…
-
shield and funnel icons
I have several cards where the filter funnel and the PDP shield block the bottom left cell on a chart's associated data table. I read something out here from early 2021 about not being able to hide those. I was hoping that had changed. If it hasn't is there a way to left justify the numbers in the data table to avoid the…
-
Possible to update multiple filtered dashboards
Hello, I currently have a dashboard of about 40+ cards that pulls data from multiple data sources and am wondering if it's possible to create duplicates, with each duplicate having a filter applied (ideally, that can't be unfiltered). Essentially what I'm hoping to do is to be able to just update the dashboard with…
-
Is there a way to suppress sections (collections) in a page/dashboard?
I would like my users to be able to suppress certain cards or collection of cards prior to exporting pages. Some times the users want more details for certain clients, and instead of having multiple pages, some with less data, and some with more, I thought it would be great if they could just filter on sections, that would…
-
Mandatory Single Select Filter
I made a Pivot Table which needs 3 Single Select filters to be done by the user, otherwise it will be summing the values (which I don't want to happen because it will show the data incorrectly), so the only way to make it completely proof of human errors is making these mandatory, but I can't find this feature. I saw this…
-
Card Level Interaction Filters
This is a pretty straight forward question. When interaction filters are enabled on a card does it only work on cards that are running on the same dataset with the interaction enabled? For example I can 1 card that I want to filter other cards, some cards are on the same dataset, some are not. I thought that similar to…
-
PDP Policy Simple Filter - don't see value in dropdown list
I am trying to filter by store number (Store No) for a particular PDP policy and I'm searching "8". The value is definitely in the dataset, but it does not appear in the dropdown list and I'm assuming this is due to some sort of limit on how many values can be displayed in it. Is there a keyword or phrase I can add to the…
-
60 days since last pmt beastmode
I have a payment column called LastPmtDate, it exactly what it sounds like. What I am wanting to do is write a beastmode to be used as a filter to filter on only those that our 60 days or greater from that payment date.
-
Possible To Update All Cards On A Dash At Once?
Hi - seeking recommendations on a faster/better way to update datasets and dimensions for all cards on a dashboard. Currently clicking through each card (80+ on one dash) to update to a new dataset, and also to remove a filter. Going to add a dash-level filter once all the card-level filters are removed, but wondering if…
-
Trying to figure out how to filter out top 20th percent of data by week in domo graph
I'm trying to eliminate outliers from my dataset (top20% highest score let's say) by week. So I'd need to filter out (by rank) top 20% of scores from each week and then graph it on a line graph. My data is dynamic and it changes every day so I can't rank the entire data set. I need to rank by week. I've seen people talk…