including blank in filter selection

[Anonymous]

Hi

I have a field in which the values are daily and hourly .. and there are some blanks .. i want to show blanks along with the Hourly and Daily values when selected .. here is the condition i am using in the script

if(Len(Trim("metric_breakdown") = 0 or "metric_breakdown"='daily'),'Daily',

if(Len(Trim("metric_breakdown") = 0 or "metric_breakdown"='hourly'),'Hourly')) as [Rum Metric Breakdown],*;

what is that i am doing wrong .. i could only see daily value in my filter

Thanks

[vishsaggi · Accepted solution]

Try this:

if(Len(Trim("metric_breakdown")) = 0 or "metric_breakdown" = 'daily' ,'Daily',

if(Len(Trim("metric_breakdown")) = 0 or "metric_breakdown" = 'hourly','Hourly')) as [Rum Metric Breakdown]