Dealing with "empty" cells on Quicksight

Question & Answer
, , , ,
1

Hi everyone, I’m currently working on analysing the sales pipeline for my Business Development team.

image
image1174×340 41 KB

The issue I’m facing is in the status column, where most of the cells are empty. However, on the CRM we use (Folk), the status is set as “No Status”.
image
image274×738 3.68 KB

How can I work with these empty values in my analysis? Is there a way I could create a calculated field where I could rename the empty cell as a “No Status” value? The goal would be to create an effective pipeline that shows the conversion rate.
image

2

Hi @rohit_SB,
You could try something like the following:

ifelse(Status=' ', "No Status")

Let me know if you have any additional questions or if this works for your case!

1 Like
3

Hi @rohit_SB,
It’s been awhile since we last heard from you so checking back in here to see if you have any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @rohit_SB,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!