gbennett Member

Hey @GrantSmith , works beautifully.

I was able to use Sum(ifnull(`Early to Lost`,0) +ifnull(`Early to Won`,0)+ifnull(`Early to Late`,0) ) AS 'Total Low to High' and enter in a beast mode.

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.