You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Filters are implemented in form of a load script. These load scripts can be set for:

    • Documents: Load scripts in documents will be applied to the whole document. Filters set here will be global and applied to all analysis parts. You can also define selections that will be applied when the analysis is reloaded.
    • Sheets: Filters that are defined for sheets will filter down everything on the sheet. But other parts of the analysis will not be affected.
    • Components: Filters for single components only have an effect on this component.
    • Stories: Filters in stories will define what part of the data will acutally be shown in the download. The analyst can predefine which selection / filter the download will show.

 

Filters:

Filters offer the possibilty to predefine what part of the data is shown in the respective part of the analysis.

 

ExampleDescription
FILTER PROCESS EQUALS 'Create Purchase Order'This example would filter for all cases that include the activity "Create Purchase Order".
FILTER YEAR("EVENTLOG"."EVENTTIME") = 2010This example would filter for all occurences in 2010.
FILTER "EVENTLOG"."USER_TYPE" != 'BATCH'This example would filter for non-automated actions in the process.

 

Selections:

Selections can only be defined in document load scripts. The selections will be applied when the analysis is loaded. It is also possible to pin selections. Pinned selection cannot be deleted by a viewer. It is only possible to reset them

 

ExampleDescription

CLEAR SELECTIONS;

SELECT YEAR("EVENTLOG"."EVENTTIME") = 2010;

This example would create a selection that has selected all entries with in the year 2010 from the eventlogs eventtimes.

CLEAR SELECTIONS;

SELECT YEAR("EVENTLOG"."EVENTTIME") AS "YEAR" = 2010;

This example would create the same selection as our first example, but the selection would be named "Year" in the selections overview.

CLEAR SELECTIONS;

SELECT PINNED YEAR("EVENTLOG"."EVENTTIME") AS "YEAR" = 2010;

This example create exactly the same selection as in our second example, but the selection is pinned. Pinned selections cannot be deleted but only be reset by the viewers.



 

 

 

 

 

  • No labels