-
Show a total for all records, not just filtered ones
I have a list of open Customers (based on a status field that I am using for a filter in the Card). I want to show total Sales for All Customers (even closed ones) but if I add a filter, I only get the total for those records filtered. Is there any way to do this?
-
Sort Function in ETL
Is there really not a sort function in ETL? I see comments from over a year ago that Domo was working on it but I don't see the option.
-
Custom sorting axes
Hey folks, I'm looking to create a chart using DAY OF WEEK. However, I can only sort the axis by descending or ascending. I want to display the bars in the order of the days of the week. Two questions about this problem: 1) Does anyone know how to modify this? 2) What does Domo use as the default to order, if I don't…
-
Domo with R for forecasting
Hi All, How do I work with R to show forecasting model for domo datasets? I have installed R and able to connect to DOMO. But where can I find R script to modify domo dataset into forecasting model.?
-
YoY, MoM, PoP % difference - using shapes & colors to indicate movement
Hi community, This is such a great way to show the direction of a difference/change when you present information in a pivot view. It's easily set in Excel table or Tableau. Gurus, is it possible to build something like this in Domo? Thanks!
-
Displaying Conversion Rates Between Pipeline Stages
I'm trying to display the conversion rate between say our stage 1 and stage 2 pipeline, to ultimately our stage 1 to closed won. The business question is "What % of my Stage 1 pipeline is converting to Stage 2?" and ultimately, "What % of my Stage 1 pipeline is actually Won? Or even Lost?" I started playing with a folded…
-
How can I change the size a card appears in my report?
I have a table which appears on my dashboard. However, it's got more columns than rows, and when I send a report, it cuts off half the table. How can I prevent this happening?
-
How to write first day of current year in Beast Mode
I'm trying to write a query but stuck at beast mode. Can anyone help me with writing 'First day of the current year' in beast mode? Thank you.
-
Gantt Chart - Average Timelines
Help, I'm struggling! Context: we primarily import and utilize from our Salesforce platform. I love gantt charts. I really, really want to utilize them. But our org really would be most interested from a macro-level view of "what is the average timeline for all of our steps/processes?" What I'm finding is that the Gantt…
-
Using Magic ETL For One To Many
I have one dataset with many, many lines with a company number. I have another dataset with one line per company with plan values in it. I want to combine the two in Magic but don't want the Plan number to repeat over and over (flatten the plan?) in the combined dataset so that the summarized number per company number in…
-
Is there a way to add multiple manual scale markers on a grouped bar graph?
Is there a way to add multiple manual scale markers on a grouped bar graph? I am trying to add 3 goal lines to a bar graph and am using the scale markers, but have only been able to add one. Is there a way to add multiple?
-
Grand Total are not exporting to Excel in Table Format
Hi Team, I have created a card using tabular format and applied grand total. When i am exporting into excel, Grand Total values are not exporting in to excel or csv format. It's working fine with powerpoint export. Thanks Bheeshma
-
Measure to Dimension
I have an ID column that is an integer and getting categorized as a Measure in Analyzer - how do I convert that field to a Dimension? Thanks!
-
When working with multiple Series' on a bar chart - having issues with sorting.
Good morning! I have attached an image RE: my specific question. I am trying to sort the attached, based on highest - to - lowest, based on "Actual (SA)." I've tried a number of assorted ways to make this happen, but to no avail (can attach those screen shots, as well - just let me know if needed). Can you please clarify…
-
how can i create cohorts in domo ?
-
Embed Everywhere: Must I require a password?
We are embedding cards using Embed Everywhere on a website for investors that is already password controlled itself. Is there any way to embed onto that site without requring a second Domo login? I believe the old embed functionality, limited as it was, could manage this. Any way to do this with the current embed…
-
Mobile App Phone Numbers
Is it possible to make a table card containg contact information such that when they click on the cell containing a phone number from the mobile app, it will launch their dialer with the aforementioned phone number ready to be called? Thanks, Nick
-
A beast mode where sum is greater than X
Trying to create a Beast Mode where I count distinct customers who have spent more than $100. The issue is I need to sum the revenue amounts because customer spend amounts cross many rows, so looking at just one row won't do it. Something like: COUNT(DISTINCT (CASE when sum(`revenue` > 100) then `customernbr` -- else 0…
-
SSO and iOS
Has anyone had trouble with SSO and iOS? Users that have a Windows machine seem to be able to log in fine, but when someone with a Mac or iPhone never get past the "Sign In" screen.
-
how to get drill down to work from an aggregated dataset to a detailed (transaction level )
I have a dataset with following 14 fields (SalesId, DealWonDate,BookingDate, Regin, SubRegin, SSD,FY,FQ,FM,FD, OMRep,SalesRep, Number of attachment,CycleTime = BookingDate- DealWonDate) The requirement is creating 1. a card with 75%tileCycletime by OMRep and by FM. 2. Drill down to transaction level I was able to…
-
Beast Mode Calculations with logics
Hi, I have a dataset like below where i want following calculations - 1. If Date, Business Name and Town, Country, Region etc is same - It counts Page rows and returns 3 or 2 or 1 2. If above fields are same, it subtracts Page Viewed Time Date rows to find time spent on each page, if starting page then it can remain 2 sec…
-
Salesforce report date importing as GMT but report is in EST.
Hi, I'm importing a report from salesforce and the Date/Time Opened field is several hours off. I thought it was the time zone but the Company Settings has it correct. Anyone else having this issue or know how to fix it?
-
Card not showng last few rows of data from google Sheets
I have a card connected to a simple google shhet where the first field is date. he card has a date filter, and My users have reported that they are not seeing data from October, which is the last 7 lines in the Google Sheet. Looking at the data source in Data Center I can see that the data has been imported, and other…
-
Exponenets in a beast mode
is it possible to do exponents in a beast mode? I don't see it in any of the guides!
-
Sum Rows in Sumo Card
Hello, I am currently trying to create a summary row for this dataset but am not seeing one in my sumo card, any help would be much appreciated!
-
Different Datasets generated from within MYSQL Dataflow versus Data Center
When I finish generating the output Dataset from the MYSQL DataFlow transform queries, I get two different output data sets. When I preview the output dataset in the MYSQL Dataflow I get this dataset. But When I click ‘Save and Run’ at the bottom of the page. I go to the Data Center -> DataSets to see the generated dataset…
-
Can i insert image into a card?
We want to use a few cards for reporting to Clients. Is there a way to insert an image into the name or somewhere on a card? The image would be our logo.
-
Trailing Twelve Months
I want to add a column to an existing data set that gives me trailing twelve months (TTM) of the amounts instead of just that day. Is there a way to do that in ETL?
-
Conditional Formatting on Drill Down Table (option for AND/OR)
I'm drilling into a card that shows me a list of servers and some other information. I'd like to use conditional formatting to change the color of the row based on some characters in the server name field. This is doable if you only have one set of characters however if you have multiple sets of characters to conditionally…
-
Regular line and step line on the same chart
I'm trying to create a statistical process control chart in Domo. Is it possible to make the data point line as regular line, but make the upper and lower control limit lines as step line on the same chart? Thanks!