-
Second line on line/grouped Bar Chart
I want to be able to ping in a second line into a mixed line/grouped bar chart, is there a way to do this?
-
How do I add multiple values to a bar + line chart?
Hi! I'm trying to build a bar+line chart with 2 y-axises(marketing spend + output) and a X-axis(date). How do I add 2 values to the Y-axis? Kind Regards /Noa
-
How do I set the card date range end date in the future?
I have a complex beast mode calculation that determines YOY (currently 2016/2017) revenue gaps by customer. It automatically calculates through the end of the current month. However, when I try to set the card date range to "1/1/2016 through 12/31/2017" it automatically changes the end date to the last date for which we…
-
grouped bar with multiple symbols
Is there not a way to create a grouped Bar chart with multiple y-axis symbols? I have 3 divisions (x axis) and i want to show grouped bar (Rev, Margin, Operating Exp) and symbols for (Rev Budget, Margin Budget, Operating Exp Buget) It would provide a quick summary of divisional performance to budget
-
Domo cards - Add a title to a card's legend
Happy Dojo day! I would like to know whether or not it is possible to add a title to a card's legend. For example, currently the legend of a pie/donut chart only shows the pie or donut slice name but it would be really useful if a title to legends could be added (in order to provide more information about what the card…
-
Comparing against a series
Happy Domo Dojo day! Does anyone have any suggestions on how to dynamically do comparisons on a series? For example, let's say you have a grouped bar graph that shows Net Sales on the Y axis, months on the X, and the series is 2017 and 2016. I can see the 2016 and 2017 sales easily enough. I can do some basic math to get…
-
Tree Map - "Other" Drilldown - Filter Defaults to Arbitrary Value?
I have a tree map which shows the top 20 Business Units by value plus an "Other" category. When I drill down into the "Other" category, the drill card places a default filter on an arbitrary Business Unit. Is there any way to avoid that behavior?
-
Beast Mode Sums not working, leading to strange sorting.
Hi there! I have 3 series made with Beast Mode: Series 1 = sum(`a`) + sum(`b`) + sum(`c`) Series 2 = sum(`d`) + sum(`e`) + sum(`f`) Series 3 = sum(`a`) + sum(`b`) + sum(`c`) + sum(`d`) + sum(`e`) + sum(`f`) I have Series 1 and Series 2 (blue and green) stacked on top of each other, and I'd like to sort by their combined…
-
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…