Wrike Analyze: Sample Widgets
Availability: Pinnacle. ; Unavailability: Free, Team, Business, Enterprise; |
With Wrike Analyze you can use prebuilt analytics boards or build up custom analytics boards and widgets. This page describes some of the custom widgets you can try out. To see the full information on how Wrike Analyze works, refer to the Wrike Analyze.
Wrike Analyze allows you to use the data from your account and build widgets based on your needs. The following list contains some widgets which you might find useful:
-
Line chart showing number of created and completed tasks (to display trends).
-
Total of project custom fields widget (to display KPI summing a certain custom field (e.g., Budget).
-
Pie chart breakdown of tasks by custom field (to show how many tasks have a specific custom field value).
-
Bar chart of tasks by folder/project, broken down by custom field.
-
Adding Project Custom Field values to pivot widget(to see all custom fields values for Projects/Tasks).
-
Adding Custom Field number values to a pivot table with aggregation (to see the values and their sum/average along with Project/Task information).
Note
Creating charts and widgets with calculated custom fields (CCF's) follows the same steps as with regular custom fields. Make sure your calculated custom fields (CCF's) are configured correctly to fully leverage their dynamic capabilities in your analytics boards.
-
If you’re creating a new board, click + Select Data 1 on the panel.
-
If you want to edit an existing analytics board, click the Edit button on the panel above the board and then click Custom widget and add the data values in the window that opens.
-
Scroll to the Task Creation Date or Task Completion Date 2.
-
Hover over the needed field name.
-
Click the More… button that appears 3.
-
Select Days 4.
-
In the window that opens, click Add More Data... 5.
-
Scroll to Task ID 6.
-
Hover over the field, click More….
-
Select Count Unique 7. The preview should automatically display trends of created/completed tasks by days.
-
Click Create.
This widget is built using formulas. To get more information on how the formulas work, refer to the Wrike Analyze: Formulas. More details on the conditional formulas used can be found here.
-
If you’re creating a new board, click +Select Data 1 on the panel.
-
If you want to edit an existing analytics board, click the Edit button on the panel above the board and then click Custom widget and add the data values in the window that opens.
-
Click the fx button 2 to the left of the search bar.
-
Type ( in the formula editor 3.
-
Select Folder/Project Custom Field Numeric Value 4 from the list below.
-
Type , in the formula editor.
-
Hover over the Folder/Project Custom Field Name field 5 in the list.
-
Click More… 6.
-
Select Filter 7 and the appropriate custom field from the list.
-
The final formula should look like this: ([Total Folder/Project Custom Field Numeric Value], [Folder/Project Custom Field Name])
-
Click OK 8.
-
Click Create.
-
If you’re creating a new board, click +Select Data 1 on the panel and select the data values from the list you want to create.
-
Click Advanced Configuration 2 at the bottom of the pop-up.
-
If you want to edit an existing analytics board, click the Edit button on the panel above the board and then click Custom widget and add the data values in the window that opens.
-
Select Pie Chart in the widget type dropdown in the upper left-hand corner 3.
-
Click + Add in Categories 4.
-
Select Task Custom Field Any Value from the list.
-
Click + Add in Values 5.
-
Select Task ID field from the list.
-
Click the Filters tab 6 in the upper right-hand corner.
-
Click + Add in Widget filters 7.
-
Select Folder/Project Custom Field Name from the list.
-
Select the needed custom field and click OK.
-
Click Save 8 to save the widget.
-
If you’re creating a new board, click +Select Data 1 on the panel and select the data values from the list you want to create.
-
Click Advanced Configuration 2 at the bottom of the pop-up.
-
If you want to edit an existing analytics board, click the Edit button on the panel above the board and then click Custom widget and add the data values in the window that opens.
-
Select Column Chart 3 in the widget type dropdown in the upper left-hand corner.
-
Click + Add in Categories 4.
-
Select Folder Name or Project Name from the list.
-
Click + Add in Values 5.
-
Select Task ID. The preview should automatically display the column chart.
-
Click + Add in Break By 6.
-
Select Task Custom Field Any Value.
-
Click the Filters tab 7 in the upper right-hand corner.
-
Click + Add.
-
Select Task Custom Field Name and choose the appropriate custom field from the list that appears. Please note, that this hides folders/projects that don’t have tasks with specified custom fields.
-
Go back to the Design tab 8.
-
Choose the needed Column type 9: Classic, Stacked, or Stack 100.
-
Click Save 10.
-
Open an analytics board and where the needed widget is located.
-
Click Edit above the board.
-
Click the Pencil icon 1 at the top of your pivot widget showing projects.
-
Click +Add in Rows 2.
-
Select Folder/Project Custom Field Name.
-
Click +Add in Rows 2 one more time.
-
Select Folder/Project Custom Field Any Value.
This will also display N/A as a custom field for every project. To exclude that:
-
Go to the Filters tab 3 in the upper right-hand corner.
-
Click + Add in Widget Filters 4.
-
Select Folder/Project Custom Field Name.
-
Uncheck N/A.
-
Click OK.
Note
Deselecting the N/A display will hide projects that don’t have any custom fields. Similarly, selecting a certain subset of custom fields in the same filter will hide projects that don’t have those fields.
-
Open an analytics board and where the needed widget is located.
-
Click Edit above the board.
-
Click the Pencil icon 1 at the top of your pivot widget showing projects.
-
Click +Add 2 in Values.
-
Click the fx button to the left of the search bar.
-
Type ( in the formula editor.
-
Select Folder/Project Custom Field Numeric Value in the Data Browser.
-
Type “,” in the formula editor.
-
Hover over Folder/Project Custom Field Name.
-
Click More… 3.
-
Select Filter 4 from the list and, in the window that opens, select the appropriate custom field.
-
The final formula should look like this in the formula editor 5: ([Total Folder/Project Custom Field Numeric Value], [Folder/Project Custom Field Name]), with certain digits added to the expressions where applicable.
-
Click OK 6 to save the formula.
-
If aggregation is needed:
-
Click the hamburger icon in Rows in the Folder/Project Custom Field Name section.
-
Select Grand Totals.
-
-
Click Save 7.