Apex Code Development You need to sign in to do that
Don't have an account?
Analytics: SAQL Grouping but keep null values
One of my dataset columns has a multiple lookup value so I need to use the 'group' SAQL statement so that I can see all of the values (otherwise it just shows one of them, seemingly at random) BUT when I use 'group' it also removes all of the rows that have null from another column I have; and it's important that I know when those rows are null. So I'm stuck, if I don't group I can see my nulls but not all my multiple-lookup values and if I do group all of my null rows disappear! Please help!
Currently, multi-value fields are not fully supported in Einstein Analytics. More information is available here.
Multi-valued dimensions (for example, those used in multi-select picklists) may cause poor performance because multi-value field behavior is undefined for group by or foreach.
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_performance_multi_value_dims.htm
Limitations of Multi-Value Fields in Einstein Analytics
- Not fully supported in UI and code - Faceting, binding, and SAQL queries involving multi-value fields will likely fail or produce unexpected results.
https://help.salesforce.com/articleView?id=000247689&type=1All Answers
Currently, multi-value fields are not fully supported in Einstein Analytics. More information is available here.
Multi-valued dimensions (for example, those used in multi-select picklists) may cause poor performance because multi-value field behavior is undefined for group by or foreach.
https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_saql.meta/bi_dev_guide_saql/bi_saql_performance_multi_value_dims.htm
Limitations of Multi-Value Fields in Einstein Analytics
- Not fully supported in UI and code - Faceting, binding, and SAQL queries involving multi-value fields will likely fail or produce unexpected results.
https://help.salesforce.com/articleView?id=000247689&type=1