Question
Include Accounts Where No Data Is Available In Bionic Rules
+2It was called out to me by a customer today that the "include accounts where no data is available" is not there in bionic rules even though we are sourcing SFDC object for this data. In customer rules the checkbox is there, but it doesn't appear that we have that capability for bionic rules yet. Is this something we have road mapped or discussed yet? They are trying to fetch a data set where they have Asset "a" with no support cases. In order to achieve that we'd need to filter for accounts where data is unavailable to build this query.
+2Could you accomplish this by doing a data fetch task on all accounts and then left merging that (to retain all accounts including those without data) on the second data set?
VP of Customer Success at Forcepoint
+3Since we can perform multiple types of joins, we should be able to get the right Accounts even without that checkbox. As Dan mentioned, you can query all Accounts, then query Accounts with cases (do a COUNT of cases by Account Id in this dataset task), and finally merge (retain all records from left dataset) to get a full list of Accounts along with their case counts. When adding a rule action, you can use the case count to include/exclude certain Accounts.
+2Marking this as "solved" due to the sustainable workaround.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.