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?
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Is it possible to exlude item from visual without filtering it out? | 11 | 685 | October 10, 2023 | |
| How to remove null from the data, it is not working throw filters | 4 | 2476 | April 2, 2024 | |
| Exclude nulls on one dimension only | 5 | 171 | June 5, 2024 | |
| Bottom 10 by Calculated field excluding Null value | 5 | 433 | January 12, 2024 | |
| Ifelse calculated field, null data not excluded | 2 | 13 | December 6, 2024 |