-
How to filter for Tags (many-one relationship - multiple tags per field)
I have a dataset containing tags in which a row might have multiple tags applied. For example: Keyword -- Tag(s) Car -- blue truck -- green, red bike -- yellow, red, purple How can I set up a filter for a dashboard/card which will allow me to filter down to just trucks and bikes when I filter by "red". Or just trucks when…
-
How do I remove the "Warning: Not All the Data is Shown" from a filter?
I'm adding a filter to categorize our sales into 3 groups. I get this message no matter what settings/chart types I try. Screenshots show all-time for the date field, but when I tried to do the bare minimum needed for the page it's on (one year) I still get the message. How do I remove this? Any workarounds or…
-
Is the data restricted for drill downs?
I am building a drill-down but seem not to have the same options as I would building a separate card. Example: I have a stacked bar overview where I am demonstrating the cutomer base by volume over months and by customer types. I am trying to create a drill down where I am showing in a pivot table view where I want to show…
-
Display additional related values under a graph
Hi all, I have a graph of opportunities that graphed by value, but I also want to display a count in the flex table underneath. I can add a count as a series, but that adds a bar to the graph that I don't want. If I deselect the series in the flex table, the bar goes away, but the text also turns much lighter. Is there a…
-
Subtotals for Time on a Card
How do I get subtotals for time calculated by beast mode?
-
Customize Color Theme / Reverse Order
I recently built a heatmap table where I want the lowest numbers up top. These start around -25 and end at -10 currently, but the numbers will change each time the chart is updated. I also only want to show 10 rows of data, so the table has been limited to the 10 top results. I want the heatmap to display negative numbers…
-
Stacked bar Legend not visible when hovering over bar value
Hi, I am using a stack bar chart to show the development for different segments over time. Because there are more than 20 segments, they are not visible all at first look. When hovering over one segment, I was wondering if there is a feature that would bring the segment in the legend a bit up in the ranking? Right now if…
-
Weekly chart showing dates that aren't correctly aggregated
A Domo user ran into an issue while creating a chart. Their problem: I have a chart plotted by week, which shows some dates which aren't correctly aggregated (always with a value of zero). I checked the underlying dataset and couldn't find anything special with the rows on these dates. Has anyone seen this before or an…
-
Is there a way to store a beast mode in a filter on a dashboard?
Is there a way to instead of having the beast mode in our cards for the guage multi value visual (Impressions, Web Page Visits, Visit Rate, etc.), have it in a filter that links to the cards in the campaign? Instead of having a static last 30 days vs previous 30 days, our client suggested that it would be great if there…
-
Colour change depending if beating last years amounts
I have a bar graph with a comparison line showing the previous year. I want the bar to show a different colour depending on if were beating the previous year or not. e.g. red if under and green if over.
-
Beastformula
I have this data with an ID column that are repeated because each unique id have 4 different event type, What I am trying to achieve is if one id with = 4 different category and are all completed in the event status column and within 45days of event date and originalenrollment date then it is completed. I have this code…
-
Rank and Windowing functions in beast mode
Hi! I had my CSM enable rank and window in beast mode, and I have created a few that work great, but when I go to save my card I get an error that says the card cannot be saved and to contact support. I submitted a support ticket - but is anyone else having this issue? And if you have existing cards with this type of beast…
-
Getting an average line chart from multiple line charts
Hi everyone! Just wanted to ask if it's possible to get an average line chart for a multiple line chart (based on a specific series). As an example, think of X = Quarter 1, 2, 3. 4 of Year 2023, Y = revenue, and series = Product 1, Product 2, Product 3. However, the tricky part is this series is based on a DOMO variable,…
-
Pivot table show only certain value under specific column
Hi, I have a pivot table with different media types as columns, and 2 types of values, instances and revenue. I only want to show sum of revenue under TV media type, and only sum of instances under Internet media type. Is this possible with one chart?
-
Pivot table - graph by
Hi, I am sure I have done this before but if I have a date as the row on a pivot table can the graph by still be used so customers can aggregate to month, year etc. The option is greyed out?? The field I am using is definitely a date field.
-
Possible to graph a linear equation?
I wanted to graph this linear equation in domo GoalVariance = (E_Rate)x + (N_Rate)y Is this possible in Domo?
-
How can I change the order of columns in chart?
Hi guys, I have been trying to reorder my chart chronologically backwards. I have 3 columns that I want from left to right, Current Year, 3 years ago, 5 years ago. The table is transposed. Every column header on the left (transposed) is a beast mode. I have tried clicking the arrows next to 'Year of Tour' and it never gets…
-
Decimal/Thousands Character
Hi, We have clients in Europe where the decimal point that separates the whole number from its fractional parts is a comma instead of the usual period/dot(.). Is there anyway to change this? So in the UK the number 28586.84 would be 28,586.84 but in Europe that would be 28.586,84 Thanks
-
Is there a way to use a matching value filter with a single select filter?
Hello! Currently, the filter control options avaiable for Quick Filter are: Match value Single select Multi-select Is there a way to use these filter controls together? For example, I may have two columns with the following values: Name Pets Ann Cat, Dog, Bird, Reptile Ben Dog, Bird Kate Bird, Reptile Tom Cat Will Cat,…
-
Can I use a filter to make a filter?
I have a dataset that is a schedule of products to promote. A different product is promoted every day and we don't want to promote the same product more than once per month, at least. I want to be able to look at my schedule (just a table in Domo) and only see products that I have not promoted over the last 4 weeks, 5…
-
U.S. Designated Market Area (DMA) Custom Chart
Since Domo doesn't have a U.S. Designated Market Area (DMA) map as part of the standard card types, I am hoping to create my own using the custom chart feature. Could anyone who has already done this provide the U.S. Designated Market Area (DMA) file in SVG, KML, GeoJSON, TopoJSON, or Shape format that they used? Thanks…
-
Scorecard First and Last shows same value..
I have this scorecard with Current and previous values and I am good to show change.... Challenge: One filter selection has no previous value and because of that, I only get one value and the card shows the same value for first and last in the scorecard.... Any tip how do i deal with this? May be a way to make sure it…
-
Group By Filter for Dashboards
Hi Folks, Is there a way to add a 'Weekly' 'Monthly', or 'Quarterly' filter to a dashboard that would aggregate best modes accordingly (when written dynamically) within charts by those groups against a date field? The equivalent of the graph by feature in the analyzer: I want someone to be able to select weekly and see an…
-
Show numbers in different format
Hi! I have a stacked bar chart whose formatting for values must follow a specific set of rules. If it is above 1 million (example 9,483,321), it will be displayed with 1 decimal place, scale-abbreviated (to 9.5M in the example). If it is below 1 million, it should be displayed with no decimal place, scale abbreviated (like…
-
Multiple Date Fields and Filters
I have one table with two date fields: date-1 and date-2. I would like to configure two filters such that filter-1 operates on date-1 and filter-2 operates on date-2. Is this possible? My experiments so far have yielded inconsistent results. I'm not sure how to control the mapping between dates and filters. Thanks!
-
Comparing 2 datasets
Hi there, I am new to DOMO and I am trying to find a way to combine two datasets with same column names. I would like to calculate the variance between current pay vs industry pay and be able to sort it by job title and location (DMA). I have tried ETL, Join and Segment for the baseline but none of these methods work for…
-
Display Values used to calculate Summary Value
Is there anyway to auto display the red text? I'd like to show the 2 values that are used to calculate the Summary Value without manual annotation.
-
Table Chart and data validation
I create my table chart with beast mode fomulae, everything looks good, but when validating the data with the numbers populating in the table chart it is not accurrate. the beast mode formula seems to be correct. Can you help or any idea of what could be wrong. Thanks!
-
Split Multi Value Column values into Separate Columns
Hi! I have a column with multiple values, separated by a comma. I am able to use the Split Column in Magic ETL and place the values into new columns. However, I need it to be added into a new column based on the value. For ex.: Fruit, Vegetables (Fruit would go in Fruit Column and Vegetables would go in Vegetable Column)…
-
Graphing multiple metrics in one chart by rank
Hi, I'm trying to create a chart that shows how different GA4 metrics show a different result for which site traffic source performs best. For example, per the screenshot below: Email has the highest avg events per session Direct has the highest share of total sessions. Or, Display has the highest avg engagement rate. That…