-
Need help reviewing sql query used to create domo sql dataflow
Hello, I am working on moving one of our SQL Queries to Domo. This query looks for users who have made a purchase in a month and no purchases in any month before or after. I was able to move this query but I am getting slightly different results. Since dates are used differently in both queries I wonder if I made a mistake…
-
Is it possible to calculate 6 months of data for a metric?
I am trying to collect Customer data Month over Month data for a metric that uses data from the past 6 months. For example - January 2022 would include customer data from July 2021 to January 2022 February 2022 would include customer data from August 2021 to February 2022 and so on.. Any help is appreciated! Thanks! Vik
-
How can i write this sql statement in domo?
where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '2020-07-01') Statement below is a column I use for an sql query.. ROW_NUMBER() over(partition by a.Customer order by MIN(a.InvoiceDate)) as OrderNum I am getting an error while trying to convert this statement. I am not sure how to…
-
Need help converting a MS SQL Query
Hello everyone, I am trying to move one of my SQL queries to Domo. I was able to move the query but I got slightly different results. I will attach the original query and the query I used to create the sql dataflow. Did I make a mistake with the dates in the query while moving the query to Domo? SQL Query select distinct…
