Tuesday, 22 October 2013

Specifying filters when the value has special characters like an apostrophe

If the analytic filter is specified as:
dimension_level = 'KPI's' 

we get an error.

This works:

dimension_level = 'KPI''s' 

A single quote in front of the special character like apostrophe takes care of it.

V1.6 will have a new way to apply filters that is visual. There will be almost no need to type filters. 

No comments:

Post a Comment