The Card Data Analyzer is a powerful data summarization feature which 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 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 the 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, go to Module menu, 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 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 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 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.

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 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.

Note1: From the exported table, you can click any of the card ids to indicate the card in the SwiftKanban application.

Note2: 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 Board menu > Analytics. On the Analytics page, navigate to the 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 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 Analytics.

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, 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. To drill down any number to view the cards 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.


10. To modify an existing table or chart, select the same from the Filter drop-down list and make 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.

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

Set Global Filters at Board Level

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

Once you if having the manager role user save the filter option, you can check mark the Mark as Global option that modifies the saved Filter name by adding a suffix after the unique name of the filter. For example, if you save a filter name as Team Spartans and mark it as Global filter than the name will modify to “Team Spartans(Global)” as shown above. This helps all the team members distinguish between as normal saved filter, which is user specific against the filter that is set to global by the manager and can be used by all users at Board level.

Note:

  • The check mark beside the option “Mark as Global” is enabled only for the manager role user who has saved the filter as Global filter. All other managers defined for the Board don’t have the access to disable the filter from Global to normal filter.
  • All Manager role users have the access to Delete the Global user. This specifically helps when the manager who had set a filter as Global is no more a member of the enterprise. In such scenarios, any other manager has the access to delete the Global filter created by the inactive user.
  • Other role users can only view and use this Global filter for their data analytics.
  • You cannot set same named filter as Global at a Board level. The Global filter should have a unique name.
  • Was this helpful?
  • Yes   No