-
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…
-
Percentage value not showing correctly in one of the series.....
Hi, Need help with card building. As you can see in below screenshot, there are 3 series of values which shows %rate. But the last one (conversion rate) is appearing as 100% which is actualy is in the range of 1-2%. I tried changing all formats (percentage, number, default... check box - divided by 100)
-
"Table" length limit
I have created a card - in "Table Format" that lists customers and some data. What I am finding is the table does not show all customers. If I add a filter and filter out what is at the top, the items that should be on the bottom appear. Has anyone else seen this? Is it a known item on Table cards? Did not find anything…
-
Plot chart with segmentation quick filters
I'm building a plot chart, where the x axis is the number of times something has been used and the y axis is the amount of money they've paid. I can simply group this information by quarter and year, which is fine. However there are different kinds of usage, and people want to be able to filter to certain quarters, type of…
-
Drill down by series
I am new to DOMO. Is there any way to create a drill down card in DOMO please? Connector I use is Excel.
-
Organize Values on X-Axis
I'm trying to order data on the X-Axis; however, the "Sort" functions appear to be limited to ascending, descending, and alphabetical. Case in point, if I have the days of the week on the X-Axis (Monday, Tuesday, etc.), I cannot get the data to go in chronological order. Is there a way to force the X-Axis to sort in a…
-
Calculating Inventory Over Time
I am trying to compute inventory levels over time based on invoices. The invoices give me the relevant data of: * Quantity coming in and date * Quantity going out and date In the Excel world, I would have just made a list of dates and done a SUMIFS function. What is the equivalent in the DOMO World? Thanks for your time!
-
Changing data sets in a drill path while using PDP - bug
I have run into an issue when trying to swap data sets when drilling into data. It appears that when this is done, the PDP policies get held up somewhere and no data comes through on the drill through. Any admin can follow the drill path and see the data, but those with PDP policies get stuck when they try to drill into…
-
Average for Multi Line Line Graph
What is the best way to add an Average line to Multi Line LIne Graph? Some cards do this automatically, wondering how to format the data, card properties to get the Average line to appear.
-
Create a donut
Good morning I would like to create a donut but I can't do it. I can only create 2 slices, I don't understand why. I need 14 slices Someone can help me ? Thank You in advance
-
why series color keep changing?
Hi Domo Experts, I have a status series in my card. Solved should be green, pending should be blue, open should be red. I set the series color in Chart properities - > Color. It works right after I set it. However, after a few days, I noticed that the color massed up. Solved changed to blue, open changed to green...etc.…
-
Updating a column or deleting rows of a table in SQL transform (saving to the source table)
Hello Everyone, I have just started working in Domo for couple of weeks and currently working on the ETL transformation. My requirement is to update or delete a column of a table using SQL transfrom and save the result to the same table. I have tried this using as individual transforms and in a Stored procedure, in vain.…
-
Is it possible to duplicate more than one card at once?
I have made a series of cards for one dashboard and need to replicate all the cards for the rest of the dashboards I have to make. Is there a way to do this faster than duplicating each card one by one?