Versions Compared

Old Version 11

changes.mady.by.user Karen Hogan

Saved on

compared with

New Version 12

changes.mady.by.user Karen Hogan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The right drawer tag will open the filter panel for every embed mode available.

...

Using

...

filters to filter a chart via JavaScript while embedded

With Category Filters (whole category)

Adding filters

To add category-level filters to all the charts in the category, you must have something with the following pattern:

Code Block
scheme://host:port/pi/#PA-CA###category/id/c-o-p=FILTERS

For example:

Filtering the category with Department = Dev:

Code Block
https://localhost:8224/pi/#PA-CA###category/141/c-o-p=eq__[[Department]]{{dev}}

Filtering the chart with Department = Dev and Number > 100:

Code Block
https://localhost:8224/pi/#PA-CA###category/141/c-o-p=eq__[[Department]]{{dev}}/*$*gt__[[Number]]{{100}}

With Temporary Filters (per chart)

Adding filters

To add temporary filters to the charts, you must have something with the following pattern:

Code Block
scheme://host:port/pi/chart#chart-filter/id/t-f-p=filtersFILTERS

For example:

Filtering the chart with Department = Dev:

Code Block
httphttps://localhost:8224/pi/chart#chart-filter/330__1/t-f-p=eq__[[Department]]{{dev}}

Filtering the chart with Department = Dev and Number > 100:

Code Block
httphttps://localhost:8224/pi/chart#chart-filter/330__1/t-f-p=eq__[[Department]]{{dev}}/*$*gt__[[Number]]{{100}}

Types of filters

Filter Name

Pattern

Object Types

Examples

Equals

eq__[[Object]]{{Value}}

Dimension

eq__[[Region]]{{North}}

Measure

eq__[[Count]]{{50}}

Greater than

gt__[[Object]]{{Value}}

Dimension

gt__[[Region]]{{North}}

Measure

gt__[[Count]]{{50}}

Lower than

lt__[[Object]]{{Value}}

Dimension

lt__[[Region]]{{North}}

Measure

lt__[[Count]]{{50}}

Greater or equals

ge__[[Object]]{{Value}}

Dimension

ge__[[Region]]{{North}}

Measure

ge__[[Count]]{{50}}

Lower or equals

le__[[Object]]{{Value}}

Dimension

le__[[Region]]{{North}}

Measure

le__[[Count]]{{50}}

Not equals

ne__[[Object]]{{Value}}

Dimension

ne__[[Region]]{{North}}

Measure

ne__[[Count]]{{50}}

Like

like__[[Region]]{{Value}}

Dimension

like__[[Region]]{{Nor%}}

like__[[Object]]{{'Value'}}

Measure*

like__[[Count]]{{'1%'}}

Not Like

like__[[Region]]{{Value}}

Dimension

nlike__[[Region]]{{Nor%}}

like__[[Object]]{{'Value'}}

Measure*

nlike__[[Count]]{{'1%'}}

Top

top__[[Object]]{{Value}}

Dimension

top__[[Region]]{{5}}

Measure

top__[[Count]]{{5}}

Bottom

btm__[[Object]]{{Value}}

Dimension

btm__[[Region]]{{3}}

Measure

btm__[[Count]]{{3}}

In

in__[[Object]]{{Val1::::Val2::::Val3}}

Dimension

in__[[Region]]{{North::::South::::West}}

Not In

nin__[[Object]]{{Val1::::Val2::::Val3}}

Dimension

nin__[[Region]]{{North::::South::::West}}

Between

btw__[[Object]]{{Value1::::Value2}}

Measure

btw__[[Count]]{{300::::500}}

Not Between

nbtw__[[Object]]{{Value1::::Value2}}

Measure

nbtw__[[Count]]{{300::::500}}

*May not work for some databases

...