user03357 Member

Comments

  • For the filter issue, there's a drop down that's available at the top after you've entered your criteria. It defaults to 'all' but if you want results that match either ABC or DEF just switch it to 'any'. For the lack of results when running a preview, when running a larger dataset only the first few lines of data have the…
    in ETL filter with two criteria on same field - fail Comment by user03357 June 2018
  • Here's the first thing that came to my mind: Full ETL: Group by: Join Data: Select Columns: Let me know if you have questions.
    in Aggregate data from multiple columns Comment by user03357 April 2018
  • You just need to move your SUM to the outside of the case statement so that it sums the 'THEN' count like this: SUM(CASE WHEN ((UNIX_TIMESTAMP(CAST(NOW() AS DATETIME)) - UNIX_TIMESTAMP(CAST(`Created Date` AS DATETIME))) / 86400) <= 1 THEN 1 ELSE 0 END)
    in Help with Formulas and Count when <= Comment by user03357 March 2018
Default Avatar