Comments
-
Thanks. So, I tried "Salesforce Connector" and "Salesforce Upsert Connector". When I check "Opportunity ID" to be used as primary key, I receive again wrong data and when I uncheck it, I receive only 2000 rows…. Any other ideas how I could get all our data into DOMO and to be replaced when something changed? Thank you very…
-
Account ID would not work as it could be that we have multiple Opportunities listed under one account. So, Opportunity-ID would be ideal as this is the data element we are looking for. When I activate the Opportunity-ID as primary key, I receive wrong data. E.g., I do have a report showing all Opportunities only for the…
-
I am using the Salesforce Advanced Connector and for the Data Selection Method, I use a Tabular Report, which is referring to a report in Salesforce. Does this give you a hint what could be the problem? Thanks
-
I have in this column all values between 1&10. Not sure if it makes sense to first create three new columns with the COUNT ( 9&10), (7&8) and (all other values) and then do the final calculation? When I create a COUNT column with COUNT(case when `Did this workshop/work session meet your expectations?` = 9 then `Did this…
-
Hi Rob, thank you very much for your help. The Count() of the individual values did work very well - thanks for this. I also tried to use the created fields/formular for the final calculation of (SUM(9&10) minus (SUM all other values))/(SUM(9&10)+SUM(7&8)+SUM(1,2,3,4,5,6)) and best to get percent as result but failed - it…
