-
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),…
-
Is there a way to organize the order of sub-dashboards by default for users?
I know how to adjust the order of your dashboards and sub-dashboards as you see them… Is there a way to adjust the order for other users who view your dashboard series with sub-dashboards? I'm fine with them adjusting later to their own preferences, but would like to have a prearranged order by default when they first view…
-
card design troubleshoot
I'm trying to recreate an excel graph in Domo. I have attached a screenshot of the excel graph I am trying to recreate. They are needing the week number on the x axis, and the distinction between the vertical bars represented with the blue and orange colors. The vertical bars represent net shipment (shipment less returns).…
-
Unabbreviating a number in a single value card
I can't believe I'm asking this question… but is there a way to unabbreviate a number in a Single Value card? I want it to say 1,253 - not "1K".
-
Scatter Chart
I would like to create a card that shows the revenue we make from each customer in a scatter chart where the size of the bubble depends on the profitability of each customer. i am very new to Domo so please bear with me
-
How to "Improve" the Histogram Chart
I have always struggled with the histogram barchart in Domo. I love the idea of the histogram, but I always end up with very odd bucket ranges. You also don't get an option of adding a series to that chart. Here is an example of a histogram I am talking about: My "improvement" is to use the scatter plot chart type. For my…