Want to have the ability to set default values on the MDA table itself
None
While working with a customer, we have noticed that there are situations where a customer may want to aggregate a null Salesforce field while pushing data to an MDA table.
In a Load to MDA rule, you can set the default value to "0", however when you aggregate a null value, the value remains null regardless of what default value you set. This is because when the aggregation happens, the aggregated value of null is null, and the MDA recognizes that as a value.
What I am proposing is the ability to actually set a default value on the field level when you create a field in the MDA. So for example, if I create a new field in an MDA table called "test 1", I'd like to have a dropdown or checkbox to set a default value in field properties when I create the field itself.
In a Load to MDA rule, you can set the default value to "0", however when you aggregate a null value, the value remains null regardless of what default value you set. This is because when the aggregation happens, the aggregated value of null is null, and the MDA recognizes that as a value.
What I am proposing is the ability to actually set a default value on the field level when you create a field in the MDA. So for example, if I create a new field in an MDA table called "test 1", I'd like to have a dropdown or checkbox to set a default value in field properties when I create the field itself.
Page 1 / 1
Like times 100!
We are working on this currently. Most likely will be delivered in the October release. The plan is to give a default value (Ex: NA or 0) field for every data type so that NULL values will not be loaded at all.
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.