-
Domo Youtube Connector
In the youtube analytics API, they allow an "averageviewduration", in their API, however, I am unable to find this metric within the Youtube and Youtube Enterprise connector. I would like assistance in finding the correct report and api connection to obtain this metric. I currently am able to find estimatedMinutesWatched…
-
Beast Mode Formula Error: This calculation is too long
I currently have a case statement within a beast mode calculation that does as follows: case when `advertiser name` like '%Microsoft%' then 'paid' (745 lines similar to the one above) else 'NA' end I get error: Invalid Formula : This calculation is too long Not sure on how to go about this. Any advice or direction on what…
-
If contains statement beast mode
I essentially have a list of URLs in one column and need to extract out the advertiser into a new column. I want to use an if contains statement to search every row in data set and see if it holds the pertaining advertiser name. Below is what I what both columns to look like and the code that I tried. COL.a COL.b url…
-
Domo Beast Mode/Data Flow
Hello, I currently have a column in my data set that is numerical called "session duration" with values ranging from 0 to 45,000 (in seconds). I want to be able to create a new column that does value mapping for values > 10 to be identified as "Greater than 10" and values < 10 to be identified as "Less than 10". Currently,…
-
Calculate Variance of a variable from two date ranges
Hello I am fairly new to domo, and I am wondering how to calculate the variance of a variable in my data set from a specific time frame (Quarter 1 2019) and divide that by then variance from another time frame (Quarter 3 2018)? So far I have tried this, but this did not match with the values from a calculation in Excel:…
