Comments
-
Ahh thank you!. Nice to know the information. Date_diff is working very well with my data when validating.
-
Nevermind I just corrected it by doing datediff to all columns case when datediff(`Closed Date`, `Created Date`) = 0 then 'Same Day' when DATEdiff(`Closed Date`, `Created Date`) < 14 then '0-14 Days' when DATEdiff(`Closed Date`, `Created Date`) < 30 then '15-30 Days' when DATEdiff(`Closed Date`, `Created Date`) < 60 then…
-
I thought I tried all possible combinations of count and sum but I guess not this one because this one worked!!! Thank you, Wendi
-
Yep, that's what I got! Any ideas on how to do this without the case then or other thoughts on adding the cases together. Thanks, Wendi
-
Actually this worked!! I was looking incorrectly at my data but this has worked! Such an easy query for the fix. Thank you so much, Wendi
-
event date, event, user login, username, user org, client name, client dob, client number, client org, client org number. The static fields here are; user login, username, user org, client name, client dob, client number. The rest of the fields may vary but if the client org = the user org I don't want the client displayed…
-
It may be that I have more columns than just the 4. I actually have several more about the client and about the user. This may be causing the discrepancy.
-
Thanks Ricardo however it didn't work. The first approach gave me the results (using my example table): It still provided Jack as a client name only where Client Org didn't = User Org. I don't want to see Jack at all. User Name User Org Client Name Client Org Phil ABC Comp Jack DEB Comp Phil ABC Comp Jack EFT Comp Phil ABC…
-
Hmmm, I'm not asking about data types. I'm wanting to see the same format as the text column in postgres, in Domo. For example the data is in html tags and indented correctly. I'd like it to keep the indentation as seen below: <responseTransformer version="3.4.2"> <inboundDataType>HL7V2</inboundDataType>…
