-
First Occurrence of Combination
I have date that includes (something like) the following DateIDClientRegion1/20/201711111AEU1/20/201711112AUS1/20/201711113BEU1/21/201711114AEU1/21/201711115BUS1/21/201711116CUS I am looking for assistance on a beast mode (or ETL Data Flow) that will pull me the name of client + Region combination that we first received…
-
How do I consolidate data from GL?
I am trying to summarize data based on a database table that contains thousands of GL entries. The problem I am trying to solve it summarizing the data based on part of the GL. For example: I have a GL that is 16 numbers long and I want to summarize data based on numbers 1-10. Is this possible? So any record with a GL…
-
Sumo Cards are not included in the PPT publised. Anyone knows why and how to fix it?
I have 3 cards on a page, 2 of them Sumo card. When I choose to "View pages as SlideShow", I see all of them. But when I downloaded as PPT, only the non-Sumo card was there. Anyone knows why & how to fix it? Regards.
-
Organize X axis
Hi Everybody, I am trying to create a graph from Excel, and I would like to show In the x axis the number of hours in a day. From 1, 2,3... to 24. My excel already includes Hours title, and the values. But when I create the chart, the x axis for some reason are not in the rate order. Instead of having from 1 to 24 they get…
-
Change Units of Y-Axis Scale
This seems like it should be something so easy to do, and I am hoping it is just something obvious I am missing... I have a bar chart showing the number of Employee Accidents our company has had, broken down by division. Currently, the y-axis scale is defaulted to count by 0.5, but that does not really make sense given the…
-
Table Column Labels -- min/max date
I have simple table view. 2 of the columns are aggregated from the same date field in the raw data. One is min, the other is max. However, when I view the card, both columns are labled as "Date_Of_Service" If I try to give them a label, the label persists for both columns. How can I give a different label to 2 different…
-
Grid Line colors
Certain chart types allow for you to change the color of the grid lines. The only default color code I am aware of is for red (FF0000). Is there a list of colors and codes available for use currently in DOMO? If the colors are limited, are there more expected to be added in the future? Thanks, James
-
How to create custom color schemes?
I would like to be able to create cards with different color schemes. I've noticed the map cards have the ability to do this with just a few simple single-color schemes, but I would like to be able to use these same schemes (and hopefully even a larger variety of schemes) with specifically bar/line graphs and all other…
-
Dynamic goal line
We have a card showing feature completion status. Now we would love to have a line indicating the % of time into release cycle. See image below for example. Is there anyway to achieve this?
-
Number Sensitive Colors
Is it possible to tie colors to certain values? So if sales is below forecast, it's red, green if it's above, etc.
-
How to create a dashed line (TrendLine)
I have a line chart now, I want one of them (the red line) to be dashed line. How can I do this?
-
Table Card > Export to Excel formatting
Hi, I've noticed something when exporting a Table card into Excel. Example: on the card , Date fields show as 2016-11-09 when send/export to Excel it shows up as 9-Nov-2016 is there a way to set the format in which the columns will be once the user export it to excel ? on export , column 1 as Tex , column 2 as short date,…
-
How do I order days of the week correctly on a card?
I have a card that calculates which days of the week have the most phone calls, so we can optimize our Customer Service Reps. The data source has the day of the week a call was placed, but when I add them to the card, they show up alphabetical, or the day that has the most calls, but not in week order.
-
Creating Percent of Total Bar Graphs
I found a nice video on the Percent of Total bar graph but when I use it I don't seem to have the same options for including various series of data as the values / goals etc. The video shows a Actual Value data series and a Target Value data series but I don't see any graph that performs that way. What I'm trying to do...…
-
goal label
How to change the goal label.? Could any one provide me a step by step instruction.? I know maybe beastmode could help. But not sure how to do it exactly.....
-
how to show birthdays on a calendar card; i have day and month information
i have 2 fields: birth day and birth month, i am try to create a birthday card that shows all birthdays on it. how?
-
Zoom in on the US county map?
We're a regional business. Wondering if it's possible to narrow in on the US Counties Map card to show a smaller area. Thanks!
-
How to build a sumo card?
Should be a simple question... How do you build a sumo card? I can't find much information about them anywhere. Thank you.
-
Card Summary/Totals
I have the following card: I wanted to know if there was a way to summarize the total orders and total sales similar to how I mocked up this sample. Any tips/pointers anyone can provide? Thanks in advance!
-
can I set fixed color to series in stacked bar chart?
I created a stacked bar chart card which has 5 series in it. then I assigned color to each series. but when I selected only 3 series the colors that are assigned to series would change. Is there any solution to assing fixed color to series independent if they are selected or not. for example if we have 3 series for…
-
Formatting Heatmap and Table card
On a heatmap, is there a way to add titles to the top (instead of the bottom, or both) and have totals at the end of the column or rows? For a table card, is there a way to add a blank column in the middle? I have six columns, but want a blank column in the middle. I would also like to be able to shade a column a different…
-
YOY calculations
I saw this post https://dojo.domo.com/t5/Domo-Dojo-Contest-January-2016/quot-Best-Beast-Mode-Formula-quot-Year-over-Year-Change/idi-p/7933 since I was having difficulty with Period over periods. Although useful it only works if you have the data range to select both years worth of data. I am trying to just isolate a week…
-
Date question
I want to limit my data visualized to greater than today. I haven't been able to find a way to do that so I have to go in and change the date each day. Can this be done automatically?
-
Can you create calculations in Sumo cards?
I want to create an average unit rate in a sumo card (revenue/units), and built it in the card itself so it is not accidently averaged or inaccurately manipulated when filtering.
-
Best practices for efficient card management
Hello, as we grow our Pages and number of cards in Domo we're running into issues for efficiently managing cards. Has anyone found a solution to automatically create or edit cards based on the same Dataset? Is there any other way to bulk manage cards? That would save hours of clicking for duplicating, just changing one or…
-
Any way to color rows based on values in a column?
I want to create a card that shows a table that has rows that are colored based on the value in a specified column. The heat map table does not work because it does not allow me to set the ranges manually. Does anyone know a way to do this?
-
Can I change the column width in the sumo cards
Can I change the column width of charts in sumo?
-
Slicer?
Because we're also using PowerBI in our enterprise, I'm constantly being asked how to do somethign that exists in Domo in PowerBI and vice-versa. I have a couple of feature questions along this line. 1) Is it possible to set up a 'slicer' that gives you checkboxes for 'Small, Medium Large' or '2013,2014,2015,2016' that,…
-
Stacked Bar with Positive and Negative Results
I've done this previously in Excel, trying to think about how I might do this in Domo, but it just isn't coming to me. What I'd like to show is this... For a given X-Axis date value which represents a transactional vintage, I'd like to show how many are still active (positive) and how many have cancelled (negative). The…
-
Trick for turning a single bar in a bar chart a different color than the rest?
I have a basic bar chart and I'd like for one of the bars to be a different color than the rest. Is this possible?