There are some common operations on each of the analytics pages that let you refine the data based on attributes, value stream or a specific time range.
The attributes are captured from your source Excel file. As the file gets loaded into the application, the system detects the attribute columns and display them on the Input Metadata page.
Any column that is set as the Card Attribute on the Input Metadata page and defined as Filter in the Card Attribute table will be displayed in the Filter pane on the Analytics page.
For example, the columns like Swim Lane and Bucket are identified as Card Attribute in the above sample screenshot and the same columns are defined as Filter in the Card Attributes table.
Likewise, all the columns that are set as Queue on the Input Metadata page and displayed in the Value Streams table appear in the Filter pane on the Analytics page.
In the above example, Project Flow End Date and Lead End Date are queues.
The Filter is available with every analytics (except Playback) and lets you refine your data either by card attributes or the workflow stages or queues through which work moves from initiation to completion.
Those columns we have identified as Card Attributes are appearing in the Filter shown in the screenshot above. The Queues are displayed under the Value Stream section which you can select to refine your analytics based on the particular workflow stages.
Note: Some filter options like Time unit and Color by are by default available in the Filter pane. The Time unit lets you render the analytics based on Hour, Day, Week or Month and Color by lets you plot the data based on any of the Card Attributes and its values.
Temporal range Filter
The Temporal Range Filter is an additional time range filter which lets you narrow the time range and focus on a specific period.
The X-axis shows the time range in months as extracted from the Excel sheet. If you use the simple Excel format, then the time range (start date and end date) is captured from the available logs (mostly from the value stream columns).
In the case of advanced Excel format, the tab Extent provides the time-range (start date and end date). It is recommended to have log data that precede the time-frame of analysis to allow the cycle time computation for cards that begin their journey through the work-flow before the start of the analysis. If not provided, it is assumed that the period of analysis is same as the start and end of the log data.
The Y-axis shows the range of workitem counts.
You can drag the slider from both the ends and narrow the time range. The charts will be automatically refreshed as per your selected time range.