-
Question on Line chart...how do I modify which metric is the line vs which is in the stacked bar?
-
Projection value per category / Plan vs Actual
Hi Domo, I have the graph attached showing monthly expenses of the company in a form of stacked bar. When I add projection value it is same for each expense category. Is it possible to stated separate projection value to each category within last month? In case it is not possible, I want at least total per month to be…
-
Dashed line and solid line for last years sales and plan
I am trying to create a bar chart with each bar having two lines (one dashed and one solid) that shows me the value of last year's actual sales and this years plan respectively. Also, i want to add that the last year's actuals and this year's plan are in a field and not static values. Is it possible to create something…
-
Changing 0 for null or blank value then filtering those out
We need help trying to change 0 values to null and filtering those values out of the view. We currently have the beastmode caluclation set to the following. We trying to change the ELSE 0 END to ELSE ' ' END or ELSE NULL END but since the field is a measure it does not allow us to input text. (CASE WHEN(SUM(CASE WHEN…
-
goal label
How can I change the label of a goal in a card?
-
Is it possible to rename column headers in a SUMO card?
I need to rename column headers in a SUMO card? Is this possible? I saw a thread about this from 2016, but don't see anything further. Thanks!
-
PowerPoint Add-In 1.1.8.0 Issue
Hi everyone, I am having some issues with the newer version of PowerPoint Add-in. As an example, when I'm importing a card it doesn't respect the card default date filters, it shows the card all time values. Is any one else having this issue or other issues with this version of the add-in? Did anybody resolve it? Thank you.
-
Custom Sort a Quick Filter?
Hello, I would like to do a custom sort on a quick filter. Currently I have attempted to concantenate a number and name in a calculated field. However since this is treated as text the sort does not work as anticipated. Example of current sorting Desired Result 1 Location 1 1 Location 1 12 Location 12 2 Location 2 13…
-
Is there a threshold to the number of quick filters i can apply to a card.
When i try to apply more than 20 quick filters to a card and try to "save and close" all the filters that were already applied, dissapear and a message pops up at the top right of the screen saying " Your card could not be saved". Is there a maximum number of filters that can be applied beyond which the card doesnt allow…
-
Building card with monthly sales targets - target-to-date
I'm fairly new to domo and am really struggling with something that seems pretty simple. I just want to create a bar chart with our monthly sales over the year but have a running line graph showing where we are in terms of target-to-date Example. If our monthly target is $17,000 how do I get that line to double in Feb,…
-
Domo Online forms (adding columns to an existing webform)
I've created a dataset using Domo's online form (also called webform). My data has 3 columns. I'd like to add a 4th column. When I try to edit the dataset I don't see the possibility of doing that. Is this possible without creating a new dataset?
-
Legends not showing when card saved as slideshow
For some reason I can see the legend when on the overview page but they disappear when I publish as a slideshow. Any ideas how to stop them from disappearing?
-
How to build a card which show the latest-date data only?
How to build a card which show the latest-date data only? Hello,I'd like to build cards based on them which show the "latest-date" data only automatically. I have a card, Its dataset which are updated by Tuesday and Wednesdey. The card's Date Range is This Week. After updated,It's a good display. but when next Monday,The…
-
Make blanks 0s in Sumo pivot
In excel there is an option you can set on pivot tables to display 0 for null fields. Is there a simialr setting in Domo for Sumo charts?
-
Google Analytics - Filter pageviews for certain directory
Hi - I'm new and just started creating my first report card. What I want to do is to display: Card 1: a table with Page URL and Pageviews but excludes everything that contains /reports/ in the url Card 2: a table with Page URL and Pageviews but includes only pages that contains /reports/ in the url (and excludes everything…
-
How to exclude current month from a card
I'm creating some cards to report on metrics for last month and some of those are a vertical bar chart for the previous 12 months. I want to exclude data for this month as it's incomplete and irrelevant. When filtering by date I can only exclude by picking a specific date, not relative such as "this month". I also tried…
-
Syntax error in beast mode case statement
Hi, I'm new to domo and struggling a bit on what seem fairly simple issues so apologies if this is a stupid question. I am using a Case statement in Beast mode to try and return the number 1 if certain criteria are met. I've managed to return the number 1 as text so far but need to return it as a number rather than text.…
-
New Analyzer - Date Dimension not Showing
All, I have an Excel sheet that I'm pulling in. Now the data in Excel doesn't have a proper Date field as the query for date is year/month so the data shows as Ex. 2017-07. So no date fields technically don't exist in the dataset, to get around this I used a Beast Mode to turn that column into a Date field (just made each…
-
New Analyzer - losing chart property selections when using "save as" to create a duplicate
Another question using the new analyzer for card building..... When I take an existing card and "save as", the copy loses the chart property selections made on the original card. Is anyone else experiencing this and if so is there a simple solution. Is there an option that needs to be selected to keep chart properties?…
-
Drag Column Here for series disappeared in new "Edit in Analyzer" feature
This is my first time using the new Edit in Analyzer rather than the old standard edit for cards. I used to be able just drag and drop columns to add additional series. This option no longer seems to be available. If I look at an old card that I created before the new Analyzer the option to drag and drop is still there.…
-
Graph Display - Suggestions/Comments
Hello, Please see attached screenshots. I have risk & opportunity for 2 different groups, FY18 and MS/DS Prediction. Is there a way I can group these differently to show up in the graph the way I want? I know whe have to take out Risk & Opportunity from the X axis because that is what is currently grouping them. But I…
-
Share card with everyone that has access to domo.
Hello, Is there a way to share a card with everyone in our organization? There doesn't appear to be a group set up with all users.
-
Show Only # Rows is Dropping Series
I have a stacked horizontal bar chart. Y = Sales Rep X = Total Sales 2017 Series = Approved or Rejected. (The series is based on a beastmode) Sorting = Sum of Amount - Decending. The data runs just fine, but when I try to use the Show Only # Rows function, It'll drop the second value created by the series and just give me…
-
Show a grand total row in a table
Is it possible in Domo to show a Grand Total row in a table? Or even write a beast mode and then show it as a row rather than a column? For example..if you take a simple chart that shows: Region Sales Orders Ave. Orders Then I'd like to show, at the bottom of the table, the total sales, total orders, and then the ave…
-
Delivering Cards as they appear to shareholders
Hello Dojo, Is there a way to send results from cards as they appear on the card rather than the underlying data. I have a chart as well as a sumo card and I woudl like to send them to shareholders in the format they are on the card - not as the raw data like when you export to excel. Is this possible? Thanks in advance
-
MID Function
Hi there, I see Left() and Right() as listed functions. Is there a MID() or some other way of performing this function in Domo? Thanks
-
Nested Bar Tip for Creating Additional Bar
Hi, I'm currently using the Nested Bar Graph to visualize both open and closed orders. I also need to put the forecasted amount on the specific region in the graph. Is there a way to place another bar in the graph to show the forecasted amount, open and closed orders per region?
-
A card displays the message "preview could not be loaded, please try again".
I assume it is an issue with the dataset, since we started having issues shortly after a data update from workbench. Does anyone know how to troubleshoot such a generalized error message?
-
YOY calculations - DOMO recommended formulas not working
I found this page for doing period-over-period calculations: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/List_of_Beast_Mode_Comparison_Calculations However, the one I really want is a YoY calculation for the same series, but when I try that formula, it comes back…
-
How do you create a chart that shows month over month difference
Sorry - I'd created this in the regular Dojo area; didn't realize I needed to post it here. So feel free to remove from regular post area. How do you create a chart that shows month over month difference? Like Excel pivot when you sum and can do "difference from". Is this something that can easily be done or do you need to…