-
Quartiles
Trying to calculate Quartiles. We found the attached, but can't get the values to display. any suggestions?
-
Is it possible to limit labels on the world map?
I am designing a world map chart to display a total value for different countries. I wanted the labels to display the country name and the value but the label starts displaying countries with no data. I tried the "Hide no data" option but it alters the appearance of the map by taking out the silhouette of the country. I…
-
Can the dashboard be interactive for selection of data? Instead of opening in detail view.
I have a drill down pie chart which is placed in collection of page/dashboard. When i click on the pie chart it is opening in the detailed view without drilling dowm. I like to display the drilled data by selecting the data in dashboard insted of from the detailed view.
-
Count of Business Days with activity mtd year over year
I currently compare business days with unit activity yoy using a yoy bar card set to MTD and displayed by day. I'm looking for a better solution that will just show the count of business days to date in the month with activity and what it was through the same date a year ago. Does anyone have something that gives that…
-
Collection base filter / Cards that ignore filter / Filter that runs on certain cards
What i'm trying to do here is make a score card of each individuals by filtering the individuals individually. There are pie charts and bar charts that needs to be filtered to make sense, i can't show all the individuals all at once. And have another card that shows the totals of all individuals. Problem is when i filter a…
-
Sumo pivot cards on the mobile app
Hi, I've set up a basic revenue reconciliation pivot as a card that displays: * ROWS - Date * COLUMN - payment method (card/cash/voucher/etc) on the * VALUE - transaction value displayed as number with no decimal places * FILTER - StoreLocation + last 7 days * Totals on It works fine on the desktop version of the site but…
-
How can I set a default page filter?
We just had our fiscal year change over so all of the cards are now showing very little data and there is no easy way for users to get back to see how FY18 ended. My thought was to set all the cards to the last 2 years then set a default page filter to FY19. Yes, the default value would have to be reset every year but…
-
Pie Chart not showing data
I have a pie chart that shows 6 things in the legend. For some reason it only shows 4 out of those 6 things because 2 of the topics are unclicked. When in analyzer I click them to show all the data but for some reason everytime I come back to the card they are uncliked and the data will not show unless I manually click…
-
How to group smaller valued groups into one single OTHER group?
Hi, I have a dataset where some of the groups are in Millions while there are several others which are in 1000s. So these smaller groups appear really small in the stacked bar visualization. I want to group these smaller groups into a single OTHERS group. How do I achiece that in DOMO? Regards, Prajwal
-
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…