jorefice Member

Comments

  • I had a similar issue where we wanted to see if the a date was less than today and highlight that specific cell red. To do I created a beast mode which put in HTML: case when `Close Date` <= CURDATE() then CONCAT( '<div style="background-color:#e45850; text-align: left; width: 100%; height:100%; margin:-20px;…
    in Applying color rules in a column Comment by jorefice September 2019
  • @meadow_ryan , Couple of questions which may help how we can narrow it down: * Are you running the ETL or just hitting preview? * What is the datatype of the gn_id column? Thanks! Jim
    in filter rows Comment by jorefice September 2019
  • @NewsomSolutions wrote:I think there are limits on how much data you can bring down from salesforce in one shot. you may have to limit it by month and then append to build your year. Just to provide an update and close the loop. I was able to speed things up by limiting the columns chosen as well as limiting the date loads…
    in Salesforce - Taken Longer than Expected Error Comment by jorefice September 2019
  • Can you provide some more details to this and possibly screen shots? What is it putting in for headers when it sometimes doesn't work? Thanks, Jim
    in Excel file upload can not generate header Comment by jorefice June 2019
  • I think it depends on the setup and if you have a existing Enterprise Data Warehouse or if you are using DOMO as one. If you do you can try and perform the complex data transformations (column manipulation, generating self joins for rankings, etc...) outside of DOMO. Then push that data in and just use Magic ETL for the…
    in When do we use Magic ETL and SQL data flows? Comment by jorefice May 2019
  • Both actually. I was primarily focusing on the data that is imported, but we should be cleansing the data associated with the DOMO accounts itself as well. We do not have a EDW (Enterprise Data Warehouse), so the data is not being replaced in all instances when it is brought into DOMO. So even if we clean up the data from…
    in GDPR - Search and Clean Datasets Comment by jorefice May 2019
  • Thanks, that may work for this scenario!
    in PDP - Policies for Owners / Simulate Policies Comment by jorefice May 2019
Avatar