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