-
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…
-
Copying Cards
It seems that whenever I try to Copy/Move a card from one page to another, the cards remain linked so that any operation on the original card or the copied card including delete or name change is kept in sync. Sometimes I just want to copy a card because there are many similarities but want to change just one simple…
-
Graph with Daily Total and Cumulative Total Bars
I am trying to recreate the below bar graph (from Excel) in Domo. In the below picture, the orange bar shows the 'Billed Amount' for that day (numbers along the bottom represent the day of the month). The gray bar shows the cumulative amount billed thus far that month (i.e. the second gray bar shows the sum of Day 1 and…
-
totals in table card
I added a grand total to a table card using the show total selection in the Total row chart property. Since it displays a total for all columns and I have a non-numeric column, I get a count for the non-numeric column which isn't needed and I'm not sure what it is counting since it isn't the number of rows. It would be…
-
Creating stacked bar chart from columns in data set
I would like to create a stacked bar chart that shows one stacked bar each for several columns in my data set, but not all of them. The number of different values contained within the columns would be the stacks. For example, say I have the attached dataset, then I want to make a chart similar to the one depicted in the…
-
Posting an SVG image file
I have an SVG image file that I would like to post to Domo using the pydomo API. Is this possible, or do I need to do some beastmode scripting?
-
Rename Column or Create New Column
Magic ETL's Join Data does not accept the join column from two different datasets if they have a different column name (even though the format of the data is the same). So I need to either rename a column in one dataset or create a new column that duplicates the data, but has a different name. Thoughts?
-
Extend x axis past the end of the data
Is there a way to extend the x-axis past the end of the data? I'm building a burnup chart to show progress on a release. The x axis is datetime values. The y axis is points completed. I'd like the x-axis to extend to the end of the release, even though there are only data values for dates up to today.
-
Is there a bug in adding pages?
There are some pages, that I have ownership of and are unlocked, that I'd like to add sub-pages to. BUT when I go to pages, the parent page does not show up on the list of pages for me to select and add a sub-page to. Is this a bug or am I overlooking something?
-
Custom Sorting Using a Field (Specifically Sales Funnel)
Not sure if this is possible or not. Basically I'm taking a a list of Sales Opportunities and putting them in a funnel by stage (Count) that way is shows how many opportunities are in each stage of the Sales Process. The thing I'm having trouble with is getting them sorted from beginning to the end vs alphabetical. The…
-
how to transpose a table?
Hello, I do have a table created and would like to transpose the data. Similar is done in Excel. Thank you
-
Pie Chart Conditional Drill Down
Hello, I have a chart with Open/Closed status and depending on the status that the user chooses, it's the custom table view they want as drill down. Example: if Closed is clicked, users want to see a Completion Date field. If Open is clicked, they want to see a Due Date Field. Is there any way to achieve this? Thanks in…