Slice creation issue

[anonymous]

Dear Team,

I have the data mentioned below. I want to create slices likes students and comments but excluding the default comment “Nil”

[Aleksi]

If I understood your request, you could use a condition rule like NOT([Complaints]=“Nil”)

[anonymous]

Thank you.

if it blank instead of nil what will be the formula

[Aleksi]

OR(
ISNOTBLANK([Complaints]),
NOT([Complaints]=“Nil”)
)

[anonymous]

thank you!!! @Aleksi

[Aleksi]

You’re welcome