Filter colums with zero values in Application Studio

Mauricio Mendoza

Hi,

I am new creating reports in Application Studio. I have a custom report that want to be filtered columns with zero value (Totals and Elements). Is there a Web Extension for this? What is the best practice to do it?  I really appreciate you comments and help on this. Thank you.

Regards,

Mauricio Mendoza

John Robson

Hi

There isn't a web extension. You can either filter a hyperblock or better a slice. Better because a slice handles better the use case that it should check multiple columns and it can easily distinguish between a stored zero and null.

You can create a report variable that controls if the slice should apply filters.

Slices do have a learning curve but are generally fast, particularly where you would otherwise want to filter nested hyperblocks. There is or should be some slice training material linked from this site.