Filter data in chart

[#1]

Hi all,

I would appreciate any help.

I have a set of data, consisting of  (subset) of data:

TicketID	State	Age
123	closed	01-02 Days
136	open	N/A
156	closed	03-05 Days
163	closed	06-10 Days
...	...	...

I want to exclude the non-closed tickets, represented as (N/A) in my graphic, as I want to represent the time taken to close each ticket, aggregated in "time-slots".

Can someone please help?

Thanks

Regards

[sunny_talwar · Accepted solution]

What is the expression you are using? Assuming it is Sum(FieldName), change it to this may be -> Sum({<Age -= {'N/A'}>}FieldName)

[#3]

Thanks,

That resolved my issue!

Regards,