-
Drill Path Filters Not Working
I'm having an issue where I've created a filter (it's filtering the month and the year formatted together). It works perfectly on the base card, but when I add a drill path and then try to drill into it, it doesn't return any values. The puzzling thing is that this used to work in the past so I'm not sure if something has…
-
Difference between dates
Hi, I am trying to create a visualization which shows the difference between 2 dates and the trend of the date differences over time(what is the average difference in dates and how they have changed over time). How can I achieve this on Domo? Regards, Prajwal
-
Heatmap Shows Duplicate Rows
I'm on a roll with asking questions here so I figure I'll keep going. I'm trying to create a heatmap to show the number of hours by group for a large set of projects but I'm running into an issue where the project name is creating a duplicate line for each group that has hours in the project. See example below. Or The…
-
Charts showing all 1s
For some reason I am seeing all ones in my stacked bar chart. I think it has something to do witht he Grouping but I am not sure. The Creaeted Dates are daily grouped as Months but it looks like it is counting only the dictince booking ids for 1 day or something I attached what it looks like. Any help, as always, woudl be…
-
How to change which day of the week is the beginning?
When you create a card that graphs data by week, the week always goes Sun-Sat. My company does a lot of reporting with the week going Mon-Sun. Is there a way to change this in DOMO?
-
Does anyone have the Beast Mode with HTML code to include an up or down arrow into a card?
I need to create a header that displays some text (users don't always click on title for descriptions) . In order to have the beast mode availalbe to select as a header, it needs to have a calclation included. I was able to get it to work by adding sum(0+0), but 0 shows up in the text. I tried using IFNULL, but then…
-
grand total of stacked bars
Is there a way for a stacked bar to display the sum total above or below it?
-
Date format on YoY chart
Hi - I have a Year over Year by quarter card, and I'd like to have the date format on the x-axis be the quarter number only, i.e. Q1, Q2, etc.. Instead, it defaults to the most recent year. From the knowledge base, it appears that there used to be a macro, %Q, but that was discontinued in the latest release. Can anyone…
-
How to show Monthly vs YTD Comparison Chart?
Hi all, I am looking to create a chart showing a comparison between Monthly and Year To Date numbers for Actuals and Forecast Thanks in advance
-
Sumo card sizing
I have a SUMO card which is displayed in a larger card format on it's originating page. When it is added to a page managed by a publication group, it shows in the smaller standard card size. I have not seen this issue with chart cards, they appear in the larger format. Is this a known issue or am I missing something?…
-
Changing a dataset on a card
How come when I change the dataset on a card it doens't change the dataset on the drill downs? Is there anyway to fix this?
-
list of countries - Map Cards
Can DOMO provide a list of all countries that are part of the Map Cards? Reason is making sure DOMO's naming conventions match the incoming data. Example is NetSuite will represent Russia as "Russia" but the Map Card says "Russian Federation". Another Example is Laos. In DOMO it's "Lao PDR". I'm assuming any country fields…
-
Days to close tickets with average as a line
Good morning everyone: I have just started using Domo and I have been tasked with taking an exec prenintation out of Excel and into Domo.I cannot figure out how to build this chart. * X - Axis: Date of ticket raised * Y - Axis: Count of Ticket ID * Stacked Bar: Grouping of ticket age * Line: Average ticket age This is what…
-
Period over period chart percent change error
I created a card using the period over period chart type that shows the year over year numbers as bars and the percent change as a line. I have run across an error when the prior year number is a negative and the current year number is positive, the percent change calculated is a negative even though the change is an…
-
Change color when value is greater than another column
Hi, Is there a way to change the color of a column based on it being greater than its comparison group column? See below for the example. If the blue column is greater than the green column, I want the blue column to turn red.
-
Unable to see Colour Rules in Scatterplot
I have set colour rules for my scatter plot to colour values above average one colour and below another. They are not taking effect on the card.
-
Hide Series from the Legend when NOT null
Searched using several different phrases but wasn't able to locate anything from previous threads on this except "Hide Series from the Legend when Null" which didn't help in this situation, so figured it would be quicker to post since it seems like a pretty easy question to get an answer for, or be advised that at this…
-
Hide card when value is null
Hello, I have a filled gauge with a percentage of achievement regarding a target. Some days, this target is null and when it's happen, the card is not relevant. So my question is : is it possible to hide the card when the target is null ? Thank you in advance for your help
-
Link Cards
Hello, If I have in one page multiple cards , but I want to link some of them with the same filter: First card is a map. when I click on NY I want the next card to filter NY too. But I would like the filter to come form clicking on the map and not from a filter in the page. I can't use drill path as the data are different.…
-
Variance from Historical Average
I'm looking to create a card that shows the percent and/or change in a value for last month compared to the last 12 month average. So if last month there was $1M in revenue but the last 12 months averaged $1.2M per month in revenue, I want to show -16.7%. This would be very similar to the "Compare" functionality on…
-
How can I sort by half hour intervals?
Hi there, I'm unable to figure out how to sort my card by half hour intervals. It seemed to be fine at first, but when changing date ranges, the intervals shift in seemingly random ways. I have a date field, `contactStart`, that's formatted as YYYY-MM-DD HH:MM:SS (example: 2018-06-18 14:41:28). I've tried the following…
-
Graph behind a graph
Hello!! Is it possible to create a card with for example the US map and when I click on any state I get the couties and when I click on the countie I want, I get a another card or a graph a built? Thanks!
-
Display the variance between two variables on multi-line graphs
How can we get the data labels to show the variance between two variables on either multi-line or running-total line graphs? It looks like the only options are to display the actual value of the variable, but not relatively to the other variables.
-
Displaying Revenue for Multiple Revenue fields on an Opportunity from Salesforce in the same Card
Hey everyone, I'm trying to build a card in Domo to display revenue from different products on an opportunity in Salesforce. What I've done so far is I've got different rollup fields in SF that display the revenue based on these different products on the opportunity. There's 3 specifically I'm worried about. They're all…
-
Show the Date Range Field Name on which the Date Range Filters are applied
How can i show the Field Name on which the Date Range Filters are applied next to Card Name? It is tough to know for an user who do not have access to analyzer what is the Field name on which the date Range Filter is applied.
-
YTD graphs
I understand Date column is mandatory to create a YOY card. But the report coming in from quickbooks does not have a Date column in it. How can i solve this issue?
-
Two or more Fields on Summary
How can i show show two or more Fileds value on "Summary Number"? I tried creating a calculated Field to include 2 or more fields however it shows really weird format on the card i.e. without comma for Numeral values and large font size. See attached Screenshot of one of the cards.
-
Adding annotations to a line or bar graph
Hi, I have a line graph that I'd like to add an annotation / text bubble to for the purpose of giving an example of why there's a spike. I'd like to tie it specifically to that spike so that as the data continues to grow, the annotation will stick with the spike. The "annotation" option appears to be greyed out for me on…
-
summing 1st and 2nd row, and then summing 1st, 2nd, and 3rd, and then summing 1st, 2nd, 3rd, 4th
Using beastmode (or another method) is there a way to sum (in a new column appearing directly to the right of the values) the 1st and 2nd row, and then sum 1st, 2nd, and 3rd rows (appearing directly beneath previously sum of 1st and 2nd row), and then summing 1st, 2nd, 3rd, 4th and so on an so forth until a few hundred or…
-
Cloning drill-down cards
When you create a new domo card using the 'save as' of a previous card, it is possible to retain all the associated drill-down views for that card as well? It appears that when you 'save as' it only replicates the primary top-card. Similarly, it is possible save a drill-down view of a card as the top level of a new domo…