I am looking at interactions leading up to a product sales. I have a calculated field for the x axis which says whether ‘email’, ‘crm’ or’ ‘email and crm’ channels were used into the lead of up to the sale. this is a bar graph which counts distinct product sales on the y axis. I have added a group by condition to split each of the channel options by scrum of the interaction which is attributed to the product sale. I used a calculated field for this which reads as ‘ifelse({INT_SELECTION} = 1, SCRUM, null)’. There are inevitably some nulls for where the scrum of a non attributed interaction is picked up. My issue is when I select the visual to ‘Exclude null’ - this results in nulls being removed but also my entire ‘email and crm’ column on the x axis which contained data from other scrums. Any idea why this could be?
Hi @mark.brocklebank and welcome to the Quick Sight community!
Would you be able to provide a screenshot of the before and after so that we can see how it’s affecting the table?
In terms of a work around; what if you used a different value instead of ‘null’ for your ifelse statement. Then filter based on that value and leave nulls included, that way you can still filter out your values without losing the other column because of the null exclusion.
Following up here as it’s been awhile since we last heard from you; are you still working on this issue or were you able to find a work around in the interim? Let me know if you have any additional questions pertaining to this topic.
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Since we have not heard back further, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you