-
Mass / bulk change data sets in dataflows
Hello, I have a dataset I replace every month. This one dataset is curently connected to many dataflows. So I have to update each workflow every month with the new dataset. Can I bulk change a dataset in many workflows at one time?
-
Cannot Perform mySQL Inner Join
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…
-
Beastmode calculation error dividing
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…
-
How can I have Domostats include historical data as well
Currently my Domostats only imports data from the date I downloaded it. How can I change that so it includes data from the past as well?
-
Concat percent sign (%) after a beast mode calculation. Syntax Error
Hi, I created a BeastMode calculation to create a basic percentage value. However, when I try to enter the formula into a concat it give me syntax error. Works: count (`Have License`) / count (`Total Users`) * 100 Does Not Work Concat ( count (`Have License`) / count (`Total Users`) * 100), `%`)
