-
Salesforce Case Reports
I have several reports that are currently manually put together and I'd like to display them in Domo with regards to Case Open Date and Closure Date. the 2 dates I have are open and closed date along with the Case detail information. I need to aggregate the data to show this below. So here's what the current report looks…
-
How to create date series with beast mode
I'm trying to create a series of data: Same Day, 0-14 Days, 15-30 Days, 31-60 Days, etc I have 2 fields Created_Date and Closed_Date. If created_date = Closed_Date then "Same Day", if Closed_date - created_date < 14 days then 0-14 Days and so on. My beast mode looks like this below. I was trying some stuff but anything…
-
Beastmode Count help
Hello, I'm looking to create a beast mode to provide a summary number but my case statement counts are not working. The data looks like this: Message Key Data Source 1 Collected Delivered 2 Collected 3 Collected 3 Collected Delivered Delivered never has a message key but collected could have duplicate message keys. I'd…
-
SQL dataflow help
Need some help from the SQL guru's out there. Table as seen below. User Name User Org Client Name Client Org Phil ABC Comp Jack DEB Comp Phil ABC Comp Jack EFT Comp Phil ABC Comp Jack ABC Comp Phil ABC Comp Jack OKA Comp Phil ABC Comp Jack IPA Comp Phil ABC Comp Jill CDE Comp Phil ABC Comp Jill XYZ Comp The situation is…
-
Keep format of native text field
Hello, my native postgres db has a text column that is formatted in html. I'm using Workbench to pull the text field out as a string but the formatting disappears when placed in Domo. Is it possible to keep formatting when seen in Domo? Thanks, Wendi
