I'm working on pulling data from an api where I will be downloading a gzipped file. Before I get too far into trying to build a Custom Connector for it, is it going to be possible to process that gzipped downloaded data in the "Data processing script"?
Hi I'm trying to make a simple Inner Join but the ETL does not produce data for some reason and my mySQL does not have the correct syntax. I've tried a combination of backticks and table.column format anfd nothing seems to work correctly. Can someone take a look please? SELECT * FROM `elevate_seats_june_28_2018` INNER JOIN…
Is there a function or variable(s) that provide the value of the selected date range (i.e. the “from” and “to” of the DOMO Between fields? I would like to select employees who were active during a selected date range. If, for example, the date range was Oct. 13, 2017 - Jan 7, 2018, then all employees who are not terminated…
Hello all - I'm trying to calculate a value through beastmode from survey data and then use that calculation to provide a stage name of Novice, Transitional and Expert. Since I cannot reference a beastmode within a beastmode, I used the calculation in every case statement and had the sum categorized as a stage name. It…
Background I posted a question earlier that had way too many parts, so I'm breaking out individual questions. Hopefully, these are easier to answer now and easier for other people to discover later. I can figure much of this out by testing myself, but am hoping others already know and can answer without much effort.…
[see attached image] Suppose I have this two column dataset: one column has the date and one has a quantity. What I need is to take a quanitity, subtract the quantity corresponding to the month before, and then divide that difference by the quantity corresponding to the month before. This is the (new-old/old) way to…
I have been shopping around for a connector on Domo but have not settled on the right one yet. The main purpose of this connector is to automate the rather arduous task of manually uploading ~25 financial spreadsheets to Domo each month. What I'm looking for: >Files can be saved locally and the connector is set up to…
I'm trying to create a BeastMode that will give me 'average views per user'. (tool 1 views + tool 2 views) / total users = average views per user CONCAT ( (sum(`Tool 1 Views`)+Sum(`Tool 2 Views`) / (SUM(`Total Users`))) ,'Views') My issue is that it VALIDATES the code but then gives me the following error: "An issue has…
It looks like you're new here. Sign in or register to get started.