-
Current day vs same week day last week
Hi, Does anyone know the beast mode to calculate revenue of last year on the same date? Current date minus one year? Thank you!
-
Adding A Distance between (miles) Column in ETL
Is there a way to add a column to the final dataset when combining two data sets? I would like to add a distance column from the employee data zip (home address) to the work location zip (shop address). If it's easier to do this in a beast mode that could also work...
-
Misleading trend line
When viewing sales history for a customer and looking at the trend for a period of time, I have noticed that the trend line can be misleading. The first example is in Domo, you can see that there were no purchases in Feb or Nov of 2017 for this customer. However, the trendline is very flat. If you were to include 0 for the…
-
What is the best way to pull Facebook Relevance Score from the Facebook Advanced Ads connector?
I'm looking to pull the relevance score from Facebook. I see it listed as an available metric, but am struggling with how to pull it from the API.
-
CASE WHEN using IN
I am trying to filter my records by specific accounts. I am using beat mode to try and do the following: CASE WHEN `Company Name` IN('COGNIZANT', 'AARP') THEN 1 ELSE 0 END Then I use this as a filter set to 1 hoping to only return the accounts I am looking for. When I run this I never get any accounts returned. Any input…
-
Daily Schedules Reports for Previous Day (Skip Weekends)
Is there a way to schedule a daily report for a card that shows the previous day, but skips weekends (Sat/Sun)? So that Monday would show the previous Friday's information? I know how to schedule the report, I just can't find a way to have it skip the weekend (using the Previous options in the report).
-
Group Bar Graph - Showing number of occurence
So in my data, I have credits, revenue, & credits with revenue at different discount levels. These data show the average revenue that I made at different discount levels. I had a promotion where 5% discount was used 10 times, 10% used 20 times, 15% used 3 times through a year. How do I show on the bar graph the number of…
-
DomoR fetch() takes too long to get a large dataset.
Hi, I am trying to fetch a dataset with 3.7 Million rows in Domo using the DomoR plugin but it takes too long (has approximately been 5 hours) for the dataset to load and has not yet been fetched into R studio. Please let me know what can be done to resolve this issue.
-
Dataset job request / Fetch Jobs
Hi, We have multiple users using workbench, and we would like to be able to sync jobs from one workbench to another. It would seems based on the Tools menu that this should be possible. But when trying to fetch jobs all I can see in the logs is Total dataset jobs found for this agent: 0. What must be done to allow sharing…
-
Finding Percentage of Total with Magic ETL
I want to create a % of total pageviews column (e.g. the row for California would be 40% for pageviews in the dummy data set I've included). I then want to divide % of total pageviews by % of population for each state in a filled map. I've read Dojo articles about doing all this with magic ETL but they are hard to follow.…
-
No longer able to upload new data via Workbench
Doing the same process every month for about a year, updating CSVs in existing jobs. But since yesterday, all my uploads fail, timing out. CSVs haven't changed in structure since last time it worked. Including an output example below... many mentions of "Stream" which I haven't noticed before... [03.16.18 11:25:30 ]…
-
Distinct values with earliest datestamp.
@ValientSpur I have a dimension table where new values found in my datasets are added, and a datestamp populated in a column. I have found that I have to do a final sweep in SQL to remove duplicates because of Domo's handling of some invisible characters found in some data feeds. A select distinct statement works for the…
-
Problems joining Salesforce number formated as text and joining CSV number formated as a text
I am having trouble using Magic ETL joining a SalesForce datasource field that is a text field (but looks like a number) to a csv field that is similar. (text field that looks like a number). I have also used the "Set Column Type" to make sure the fields are text. I have successfully used vlookup in Excel to join the…
-
Hide Title on Document Card
Is there a way to hide the title of a document card so that it does't appear when looking at a page. I've uploaded an image that is very minimal and the title is just redundant.
-
Formatting font & color of X & Y Axis labels
Is there a way to Format font & color of X & Y Axis labels
-
Time Zones and DST
First of all I am bringing in my data through workbench and using the Shift Date Timezone Transform to convert my data from EST to UTC. Our company settings are setup for EST. All of my dataflows have been using the convert_tz() function on the datetime fields and everything was working until Daylight Savings Time began.…
-
Beastmode with field names that have an apostrophe
Hello, I am having an issue with Campaign Names that have apostrophies in them, and also that their name conversions also need apostraphies. Unfortunately it seems the only way I know to indicate a text string is with ' ' that interupts the word. Is there a way around this?
-
Infusionsoft API custom connector
Hi, I want to load all my infusionsoft data for visualizations. For this, I would need to create a custom connector using the DOMO API and Infusionsoft API. QQ's 1. Has anyone done this before? 2. What are the steps & approximate time involved in doing the same? Any feedback will be highly appreciated. P.S: I'm not a…
-
Can we use "Iframe" in Domo?
Hi , Is it possible to include "iFrame" in DOMO cards? Is there any option or workaround available currently? I see some old request conversation happened last year and wanted to check any progress or update latest so far on this. Thank you, https://dojo.domo.com/t5/Card-Building/Iframe-in-Domo/m-p/3765/highlight/true#M174
-
ETL
What is beast mode?
-
"Append to DataSet" method is creating duplicates
In a nutshell: 1) create & build the initial dataset in workbench SELECT * FROM myTable -- WHERE StartDateTime > '!{lastvalue:StartDateTime}!' ORDER BY StartDateTime 2) update job method from Replace to Append: a) uncomment my WHERE clause in my query b) update/add "replacement variable" subtab Column = StartDateTime Value…
-
can we add Colors to SUMO card?
I have a sumo card created, and it has some calculations, which has range of percentage. And I have a threshold for certain percentage range like- 0%- green color. 1-50 % Yellow, 50-100% - Red color. I know we can see this in Card - Color properties. But is there a way we can do it in SUMO Card. As Business User is…
-
Need suggestion on how to bring in huge amount of Adobe Analytics data
Hello, I am using Adobe Analytics Advanced connector to export data. I created my own dataset by using Intermediate -custom for report type, I selected 4 elements and 10 metrics. I also setup the following to include as much data as possible. However, because the data set is too big, I could not pull them into Domo via the…
-
How to Get Quarterly Trend Numbers
I think this is a pretty basic question. I am trying to create a card that shows our quarterly trend for revenue. Ideally I would do this through the formula ('Revenue' / DayofQuarter). Unfortunately, while there is a DayofWeek, DayofMonth, and DayofYear function, there is no formula for DayofQuarter. Thoughts on how I…
-
Can i setup DOMO Workbench in other disk( not C disk)
Dear, Since my c disk space is very small. How can i setup domo Workbench in other disk? Thanks.
-
Dashboard Maintenance at scale - six sub-pages, 100 cards, one publication group.
I manage a dashboard for my client. My client has access to the dashboard via publication group. My client has access to a dashboard via publication group. The client has six marketing programs. Each program uses the same marketing channels. We need to report on the marketing performance for each program, and so we have…
-
Vlookups in DOMO. How do we use Vlookup functionality in DOMO in Beast Mode ?
-
Data appending not working
Am trying to append the data using replacement variables but when the query is run the result is not the corect one. (eg) Scenario 1: Query used: Select * from t1 where time_stamp>'!{lastvalue:time_stamp}!' order by time_stamp asc time stamp value is null for the first run and hence all the records are loaded After the…
-
"Governance: Card and Page Ecosystem" App - Does the "No Owner" option work
Hi, Does the "No owner" checkbox work for others of you ? I'd like to use it, as per the suggestion in the attached "Governance: Card and Page Ecosystem" App. I click it and then click apply and nothing on the underlying list changes. This is both for Cards and Pages. Thanks, Jonathan
-
Getting Records / Incremental records - using API
Question 1) Let says if there is 2 M rows, will a single API call get 2 M rows in csv format? Question 2) I dont think there is a way to get inceremental data from a table store in the table. I would like to get inceremental data rather than downloading the entire dataset. Can I do that by putting in an extra query in the…