-
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…
-
Color rules not working with bar + line chart
I have a bar + line chart where I am using partner_name dimension (blue) in the SERIES field along with another numerical metric (green) as shown below Despite applying color rules on the partner_name field in the card, I am not seeing the color change when I change the filter values for this field in the dashboard. But…
-
Is there a reason why you cannot change the legend labels in a Period over Period chart type?
I'd love if there was a quick way you could change them like you can to the y-axis for example when you click the dropdown. I know there is a way in a normal bar + line chart to make a beast mode for the time period you want and add it to series to manually plot the bar and line against each other a year apart but I have…
-
Average Function in Summary not calculating as per card level aggregation
Here is a Scenario My Data is at Monthly Level so 1 value corresponds to each month. e.g. 01 Jan 2022 - 100 , 01 Feb 2022 - 200 , 01 Jan 2023 - 300 , 01 Feb 2023 - 400 Now in Card Summary I have selected Value column and Average Function When I select Graph by - Month Summary figures value comes up as 250 (1000/4) But when…
-
Ignore some page filters in cards or pages
Is there a way , where you can set a card to ignore some pages filters but accept others . if i have one datasource and a card with a precalculated value at YTD filtered by a dimension. and a filter on country and i have another card that i want dynamic as MTD, o CTD depending on what the client pre selects. and country…
-
Exporting Card to PowerPoint only Displays First Page of Data
When trying to export a card to PowerPoint, the export only contains the first page of data (see example).
-
Chart showing a blank date as a day when graphing by week
I have some cards where single dates are shown on weekly breakdown. As you can see, it is listed by week, but there is a date right in the middle that is listed as one day, but it is blank. This should not be showing by day and it shouldn't be showing the date if it is blank correct? What am I doing wrong?
-
Dropdown filter only seeing a few options
I have a dropdown filter card that is not showing all available options that should be showing up. Here is the filter card: As you can see I only have 2 options in the dropdown, but if you look at the filter for the same column: You can see that there are many more that this filter should be seeing in it's dropdown. Why…
-
Beast mode formula
if "event type" is not equals to "current physical due" but the the "enrollment date" is still within 90days from today then its consider as pending and here is my formula: CASE WHEN Event Type <> Current Physical Due AND ABS(DATEDIFF(NOW(), Enrolled Date)) < 90 THEN 'pending' ELSE'' END but it's not working, please help!
-
How to fix hover percentage on 100% stacked chart
I have a 100% stacked chart… and the percentages are correctly displayed on the bars by default. However, when I hover over a value in the legend, it will show what appears to the be value of the Y Axis (expressed as a percent). So for example, Email should be around 2-3% (as displayed in the first and second screenshots),…