Dashboard filters can be applied to the software by a host application or website by manipulating the parameters passed through URL. Filters are entered in the following format:
dsfilter={dataset id:column id:column value:operator type}
Where the column value is the exact value as it appears in the dataset. Multiple column values can be applied to the same filter using a comma as long as the operator type supports multiple filter values.
Like so: dsfilter={dataset id:column id: column value 1,column value 2:operator type}
The operator type is a numerical value to specify the type of filter applied to the data. The type are arranged according to the following key:
0 = EQUALS
1 = INLIST
2 = BETWEEN
3 = NOT_EQUALS
4 = NOT_INLIST
5 = NOT_BETWEEN
6 = GREATER_THAN
7 = LESS_THAN
Multiple filters can be added by using a semi-colon to separate them. Filters will be activated for all applicable dashboards used in the tool while they are active in the URL.
Like so: dsfilter={dataset id:column id:column value:operator type;dataset id:column id:column value:operator type}
In an unencrypted URL this would look like the following:
http://MyIntuitiveDashboards.MyDomain.com/dashboard.html?user=GUID&dsfilter={dataset id:column id:column value:operator type;dataset id:column id:column value:operator type}
Example: Open two dashboards (containing 3 datasets) filtered for the last 12 months.
/?User=635B4FGD-8H8E-472C-A0FF-388AD7FGC5D1&dashids=342,343&dsfilter={58:1990:0,11:2;61:2002:0,11:2;74:2050:0,11:2}
This undertakes the following:
- ?User=635B4FGD-8H8E-472C-A0FF-388AD7FGC5D9 Logs the user in via their GUID
- &dashids=342,343 Opens the dashboards 342 & 343
- 58:1990:0,11:2 Filters the dataset ID 58, Column ID 1990, Between 0 and 11
- 61:2002:0,11:2 Filters the dataset ID 61, Column ID 2002, Between 0 and 11
- 74:2050:0,11:2 Filters the dataset ID 74, Column ID 2050, Between 0 and 11