📊 Releases - Pivot Tables Available in New Dashboards (01/22/2024)
Feature Updates
- New Dashboards - Pivot Tables Are Here! 📌
We're excited to announce that Pivot Tables have been added to our New Dashboards as another visualization type. This addition, a staple in data visualization, allows you to view your chart data in a tabular form. Whether you're combining tables and charts on a single dashboard or using them for more report-like presentations, Pivot Tables offer a familiar format for spreadsheet enthusiasts.
Here's something to note: there isn't a separate visualization tile for Pivot Tables. When a metric is selected in the widget editor, you'll see a Pivot Table; without a metric, you'll see a list or table of tasks/projects. You can easily switch between Pivot and task list by selecting a metric.
This is just the initial release, and we're planning further enhancements. We encourage you to try out Pivot Tables and share your feedback. Your insights will help us improve this feature to better suit your needs.
Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Lisa Wrike Team member Become a Wrike expert with Wrike Discover
Great news Lisa,
have you in planning the possibility to add more fields and calculations (like sum, average, count) in Pivot?
Hey Pietro, what specifically are you looking for? The aggregation method for custom fields is defined in their settings so you can select between sum and average, and for built-in metrics, we use whatever aggregation makes more sense for them.
Vladimir Bugay Community Team at Wrike Wrike Product Manager Узнайте о самых популярных функциях Wrike и советах по его использованию
Vladimir Bugay Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
Hi Vladimir Bugay, thanks for your response.
For calculations ok.
I've a Pivot where count all SEO projects and give me the amount of each language divided by specialist who work on
I need to add totals for each raw and column
Thanks, Pietro! As Lisa mentioned in the original post, we are planning further enhancements, and we will definitely consider row/column totals to be a part of that wave.
Vladimir Bugay Community Team at Wrike Wrike Product Manager Узнайте о самых популярных функциях Wrike и советах по его использованию
Vladimir Bugay Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
Is there any plan to add the ability for Subtotals and Grand Totals in pivot table? This seems like a pretty basic ask for any pivot type of table format. For example if I want to create a pivot of projects by assignee (rows) and status (columns), I should be able to turn on totals for either the rows or columns to see total projects in each status or total projects assigned to each assignee.
Amy, it's already possible to have total (but not subtotals) in the pivot table. For that you need to select Display as Ratio option under the Design tab.
Vladimir Bugay Community Team at Wrike Wrike Product Manager Узнайте о самых популярных функциях Wrike и советах по его использованию
Vladimir Bugay Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
Vladimir Bugay I tried what you've noted above and it is not working in my dashboard when trying to add a subtotal based on a number-formatted custom field. Should this feature work with custom fields or does it only work for "time spent"?
Amy, it should work for any metric, but I can't help without understanding the details. You may share screenshots there or file a ticket with the support privately so we can take a look.
Vladimir Bugay Community Team at Wrike Wrike Product Manager Узнайте о самых популярных функциях Wrike и советах по его использованию
Vladimir Bugay Wrike Team member Узнайте о самых популярных функциях Wrike и советах по его использованию
Vladimir Bugay, I've opened a ticket with chat support to have this investigated. Thanks.