- Last Active
Hey @GrantSmith , works beautifully.
Hey Grant, I would think, that if I pulled the data in a sumo card, I could group specifically on a year-month and product line and it would provide the % of Low to High. But rather it adds the % of Low to High for all records. I hope that makes sense. I appreciate your help. Thanks.
Hey @GrantSmith Grant, This my statement: SELECT DATE(`order_date`) - INTERVAL (DAYOFMONTH(`order_date`)) DAY + INTERVAL 1 DAY ,SUM(`order_value`) AS `Punchout Revenue` FROM `punchout_all` Receiving this message: The database reported a syntax error: Incorrect column name 'DATE(`order_date`) - INTERVAL…
Hi @GrantSmith, Thanks for your help. I am doing this in a SQL Transform creating a table. I received this message on execution. I received a message that "The database reported a syntax error: Incorrect column name 'DATE(`order_date`) - INTERVAL (DAYOFMONTH(`order_date`)) DAY + INTERVAL 1 DAY'" Any advice would be great.
Worked perfectly thanks so much!!
I was not able to recreate a recursive data flow using this technique. Not sure what I did wrong, but I will get support at Domopalooza.
This worked perfectly. Thanks.