In this article, we will help you understand the card data analyzer feature.

Skip Ahead to:

Overview

Key Features of the Card Data Analyzer

Card Data Analyzer at the Organization Level

Card Data Analyzer at the Board Level

Overview

The Card Data Analyzer is a powerful data summarization feature that you can use to quickly summarize the organization or board data in a tabular or chart format.

Using this highly scalable analytics, you can extract voluminous data either from your board or organization and visualize them in a tabular or chart format to monitor the data trends. Moreover, you can refine the data based on a specific period and also design the analytics based on various attributes like Class of Service, Owner, Category, and so on.

You can use the Card Data Analyzer both at the  Organization and Board level.

Key Features of the Card Data Analyzer

  • Visualize the data both at an individual board and organization level. So, the information at the organization level can be aggregated from the various boards, whereas the same at the board level provides you with more specific information.
  • Refine the data as per the status of the card Active(Default) and based on custom date fields like Created On, Last Updated On, Done Date, Due Date, or any customized field by selecting the appropriate option under Date Field and define the period of the analytics by specifying the start and end date.
  • Select the type of table or chart from the variety of options, such as Table, Bar Chart, Line Chart, Bar Chart, Heatmap, Row Heatmap, and so on.
  • Select the method of summation such as Count, Sum, Average, Minimum, Maximum, 80% Upper Bound, Sum as Fraction of Total, and so on.
  • Drag and drop attributes like Card Types, Class of Service, Priority, Iteration, and others to the Row or Column label and render the table or chart according to your requirement.
    Note: The custom card attributes are also available for drag-drop.
  • Save your table or chart with a unique name and reuse it later to visualize a similar type of information.
  • Access the analytics offline by exporting the tabular graph into Microsoft® Excel.

Card Data Analyzer at the Organization Level

1. To access the Card Data Analyzer at the organization level, click the More Options icon on the control panel, click  Dashboard, and then click the Card Data Analyzer link.

2. Select the Board Status for which you would like to generate the report. You can select any of the options: Active, Closed Boards, or both of them.  Read this Help page to know more about the Closed Board.

3. Select the Board(s) and the Card Type(s) for which you want to generate the Pivot analytics. Both of them will be available based on the selection you made for the Board Status field. For example, if you have selected Active Boards only, then all the active Boards and their Card Types will be available in the drop-down.

4. Select the Custom Fields checkbox if you want to fetch the custom fields to the Pivot table to be added in a row or column.

5. To refine the data as per the status of the card Active(Default) and based on custom date fields like Created On, Last Updated On, Done Date, Due Date, or any customized field select the option listed under the Date Field option.

6. To view the analytics for a specific period, enter the Start and End date and click Go.

Note: The cards that are created or modified between the Start and End date will be considered in the Analytics. Depending on the card status, the system considers the data by checking the following scenarios:

  • If the cards are open/active (that means the Done Date field under the Additional Details section of the Card i-Form view will be blank), then the system checks if the creation date of the card (refer to the Created On field under the Additional Details section) is on or before the end date entered by the user in the date range for the Card Data Analyzer.
  • If the cards are Done/closed (that means the Done Date field under the Additional Details section will have a value) then the system checks if the done date of the card (refer to the Last Updated On field under the Additional Details section) is on or after the start date entered by the user in the date range for the Card Data Analyzer.

7. Select the table or chart format from the drop-down list.

8. Select the summarization method such as count, average, sum, and others from the drop-down list.

count method

9 . To plot the table or chart, drag and drop the required attributes to the Row and Column level.

Note: Apart from the card attributes, we have also added the following fields for better analysis:

  • Done Date
  • Done Month
  • Done Year
  • Due Date
  • Due Month
  • Due Year
  • Title field

10. You can further refine the data by selecting the specific values of an attribute. To filter and select the required values, click the arrow icon in the attribute box, select the required options, and then click OK.

11. To save your current table or chart, click the Filter Settings  icon,  enter a unique name in the Save as New field, and click Save As.  You can access the same table or chart later by selecting that name from the Filter drop-down list.

12. To drill down any number to view the cards that contribute to it, click the number. The associated cards are displayed as a list. To get the details of any card, click the card ID or title from the list.

13. To modify any existing table or chart, select the same from the Filter drop-down list, make necessary changes, and then click Save. To delete the table or chart, click Delete.

14. To export the table into Microsoft® Excel, click the Export icon.

Using the Planned Start Date and Planned End Date attributes in the Card Data Analyzer (CDA) you can refine your card data more effectively and visualize data based on planned timelines.

Notes:

  • From the exported table, you can click any of the card IDs to indicate the card in the SwiftKanban application.
  • The export option is available for the tabular graph only.

Card Data Analyzer at the Board Level

1. To access the Card Data Analyzer at the board level, go to the Board menu > Data Analyzer > Card Data Analyzer.

Card Data Analyzer

2. To refine the data as per the status of the card Active(Default) and based on custom date fields like Created On, Last Updated On, Done Date, Due Date, or any customized field select the option listed under the Date Field option.

3. To view the analytics for a specific period, enter the Start and End date and click Go. All the cards that are created or modified between the Start and End date will be considered in the CDA.

Note: The cards that are created or modified between the Start and End date will be considered in the Analytics. Depending on the card status, the system considers the data by checking the following scenarios:

  • If the cards are open/active (that means the Done Date field under the Additional Details section of the Card i-Form view will be blank), then the system checks if the creation date of the card (refer to the Created On field under the Additional Details section) is on or before the end date entered by the user in the date range for the Card Data Analyzer.
  • If the cards are Done/closed (that means the Done Date field under the Additional Details section will have a value) then the system checks if the modified date of the card (refer to the Last Updated On field under the Additional Details section) is on or after the start date entered by the user in the date range for the Card Data Analyzer.

4. Select the table or chart format from the drop-down list.

5. Select the summarization method such as count, average, or sum from the drop-down list.
count method
6. To plot the table or chart, drag and drop the required attributes to the Row and Column level.

Note: Apart from the card attributes, we have also added the following fields for better analysis:

•Done Date
•Done Month
•Done Year
•Due Date
•Due Month
•Due Year


7. You can further refine the data by selecting the specific values of an attribute. To filter and select the required values, click the arrow icon in the attribute box that you have dropped into the row or column, select the required options, and then click OK.

8. To save your current table or chart, enter a unique name in the Create New Filter field, and click Create.  You can access the same table or chart later by selecting that name from the Filter drop-down list.

9. Click the number to drill down any number to view the cards that contribute to it. The associated cards are displayed as a list. To get the details of any card, click the card ID or title from the list.


10. To modify an existing table or chart, select the same from the Filter drop-down list and make the necessary changes. It will autosave the filter.
11. To delete the table or chart,  select the filter and click Delete.
12. To export the table into Microsoft™ Excel, click the Export icon.

Notes:

  • From the exported table, you can click any of the card IDs to indicate the card in the SwiftKanban application.
  • The export option is available for the tabular graph only.

Set Global Filters at Board Level

A global filter can only be set by the user having a “Manager” role. As compared to a “Member” or “Reader” role, the “Manager” can view and enable an option, Mark as Global beside the Filter option at the top.

As a Manager, if you want to share a saved filter with other Members of the Board, you can select the Mark as Global checkbox. Enabling a filter as global modifies its name by adding a suffix after the unique name of the filter and also making it available for other Members to use in the Card Data Analyzer. For example, if you save a filter name as Team Spartans and mark it as a global filter then the name will modify to “Team Spartans(Global)” as shown above.

This helps all the Members distinguish between a normally saved filter, which is user-specific against the filter that is set to global by the Manager and can be used by all other Members and Managers of the same Board.

Important Information

  • The checkbox beside the option “Mark as Global” is available only for the Manager who has saved the filter as a global filter. All other Managers of the same Board don’t have access to disable the filter from global to normal filter.
  • All Managers have access to delete the global filter. This specifically helps when the manager who had set a filter as global is no more a part of the enterprise. In such a scenario, any other Manager of the same Board can delete the global filter created by a user who is now inactive.
  • Other role users like Members can only view and use this Global filter for their data analytics.
  • You cannot use the same name for two global filters on the same Board. Each global filter should have a unique name.
  • Was this helpful?
  • Yes   No