-
Nested UPDATE statement not populating column
I am trying to update a dataflow with MySQL. I have a report being pulled into DOMO from Salesforce and I altered it as follows: * connected Salesforce report to DOMO * Used ETL to filter the data into five buckets. (Marketing Channels) * Created a new column: 'Sub Channel' - value: NULL * Output as its own ETL dataflow I…
-
MYSQL code for Date Ranges and populating new column with fiscal week problems.
I have two data sets. The first data set is full of leads/opportunities (FY18 MQLs) and I want to automate populating a column with the fiscal week it was created. For example: 'Created Date' = '10/02/2017' Would be between 10/01/2017 and 10/05/2017 (Q1W1).. Our reporting weeks are from Friday to the following Thursday,…
-
Setting Goals for each Quarter in Bar Chart
I am trying to set goals for each individual quarter. My data is currently represented as a stacked bar chart and would like to make the goals a line. My series is calculating the count of each type of lead for each fiscal quarter. I am having trouble with my beastmode calculation setting the goal value of leads for each…