In Data Designer, if no records are being pulled, how can I ensure that we get zero as a value instead of ‘No Data’.

HI ​@parulgoswami -- where are you seeing the “No Date” message rather than a “0”?  In reports that you are building from the Data Designer with “Group By” aggregations?  Or are you pivoting in DD with aggregations?  

No need to answer if you will be on the call in a few hours, but wanted to double-check beforehand if you happen to see this!

Scott Drost

Hi Scott, 

In Load To Survey task, there's 2 survey responses from the same company, email address and date but different case numbers however I am getting a partial success result and the failure reason is duplicate record.

Is there a way to make sure that the second survey is loaded to the survey object?

Thank you.

Charmagne

Scott, I am seeing ‘No Data’ message when I am pulling relationships with end date in the previous month in data designer. If there are such relationships, then the DD gives ‘No Data’ rather than giving a zero. I am trying to leverage Case Field Builder, but it is not working for me.

We can talk it through during the session, ​@parulgoswami , but my guess is that you’ll have to expand your query for a count -- Data Designer is unique in that every time it run a specific DD, it purges all the rows in from the last DD run from the object that the DD created, and then loads a fresh dataset into the empty object.

That means that if you are creating a report based on that DD, there isn’t anything that the report can grab to return a “0” -- you get the “No Data” response.

Let’s look at your use case during the session, though -- once I know what the end goal is -- basically, where this 0 is supposed to appear for the user and what it needs to be used for -- there might be a different way to go about it.  At the very least, we can probably come up with some ideas for a kludgy workaround!