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;…
-
@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
-
@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…
-
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
-
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…
-
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…
-
Thanks, that may work for this scenario!
