Introducing Pivot Views!

What's New


We're so excited to bring you a brand new way of analysing the data you have in TrackVia: Pivot Views! 

A Pivot View is a versatile tool to help you summarize the information in a table by slicing and dicing data so you can look at it from different perspectives. It works by grouping records together based on several factors, then summarizing the data from those records, either by counting the number of records per group, or by using a specific summary function (like sum, average, or maximum) on another field. It's useful when you have lots of numbers that need summarizing, when you want to compare subsets of data, or when you’re trying to find trends in your data.

Our new functionality comes out of the gate with pivoting on multiple rows / columns, sorting pivot data, applying conditional formatting, and an easy to use designer.  We think you'll love it, give it a try today! 



How it works


Pivots are created by converting an existing grid view (default or custom) into a Pivot view.  Simply hit the Options menu in the upper right and select Pivot from the menu.  Our new Pivot designer slides out from the right and you can apply your desired settings: 


Name your Pivot something unique, select some Rows, Columns and Values and Save your settings.  Your new Pivot is displayed! 
In the above example, I selected my Rows to be 'Inventory Items', my columns to be the 'Create' date, rolled up by Quarter and the Sum of the 'Cost Subtotal' as my summary function.  

To apply conditional formatting, hit the Options menu again and add a Conditional Formatting Rule.  I created a Pivot rule where the Cost Subtotal is less than $100. 


Check out our knowledge base article to find out more details on how to configure your pivot, things you can do with it (export!) and more. 

Coming soon to our GOV, HiPAA and Private environment customers. 

Product Release Notes

  1. iOS Mobile App v5.2.4 - Sync Upload Maintenance
  2. iOS Mobile App v.5.2.3 - Resolve App Crash for Album Permissions
  3. Android Mobile App v3.3 - Chart Labels, Maintenance, and Performance
  4. iOS Mobile App v5.2.2 - EXIF, GPS, and Photos
  5. August 2020 Web Maintenance
  6. Android Mobile App v3.2 - Sandboxes: App Admin Access and Flows! Proceed through Empty Grids
  7. iOS Mobile App v5.2.1 - Stability Improvement
  8. iOS Mobile App v5.2 - Performance Improvements and Maintenance
  9. Introducing App Admin Access to Sandbox!
  10. Dashboard Tabs
  11. July 2020 Web Maintenance
  12. iOS Mobile App v5.1: Dashboards and Dates
  13. Android Mobile App v3.1: General Maintenance
  14. June 2020 Platform Maintenance
  15. TrackVia Mobile - Dashboards Reimagined!
  16. TrackVia's New Look
  17. Update to Flows - New Exit Button And More!
  18. Advanced Link to Parent
  19. New and Improved Lanes View!
  20. Introducing Backup and Restore!
  21. View Filters + Web Maintenance
  22. Android Mobile App v2.24.1: Resolved Workflow Decision Conflict
  23. February 2020 Web Maintenance
  24. iOS Mobile App v4.5: Voice Memo, Barcodes, Manual Sort, and Charts
  25. iOS Mobile App v4.4.2: Resolve Unintentional Logouts from the App
  26. Web Maintenance January 2020
  27. Web v20.10: New Permission & Enhancements to Bulk Select
  28. Android Mobile App v2.23: Side by Side Multi-Select and Maintenance
  29. December 2019 Web Maintenance
  30. Microservices Update
  31. iOS Mobile App v4.4.1: Login to Sandbox Environment
  32. iOS Mobile App v4.4: Locations, Directions, and Maintenance
  33. October 2019 Web Maintenance
  34. iOS Mobile App v4.3.1: Logout Issue Resolved
  35. October 2019 Platform Maintenance
  36. Introducing Pivot Views!
  37. Android Mobile App v2.21.7: Maintenance Release
  38. iOS Mobile App v4.3: Sync Center Enhancements and Maintenance Release
  39. September 2019 Platform Maintenance
  40. September 2019 Web Maintenance
  41. iOS Mobile App v4.2 Maintenance Release
  42. August 2019 Platform Maintenance
  43. Android Mobile App v2.21.6: Maintenance Release
  44. Introducing TrackVia Integrations!
  45. Android Mobile App v2.21.5: Maintenance Release
  46. August 2019 Release Notes: Web Maintenance
  47. iOS Mobile App v4.1: Updates to Grid Views, Multi Select Widgets and Date/Time Stamps
  48. June 2019 Maintenance
  49. New in Mobile: iOS v4.0 - Simplified Offline Data Sync
  50. iOS Mobile App v4.0: Release Notes
  51. May 2019 Release Notes: Web Maintenance 2
  52. May 2019 Release Note: Web Maintenance
  53. App Script Constants!
  54. April 2019 Release Notes: API Maintenance
  55. Entity Relationship Diagram Improvements
  56. Improved Lanes View!
  57. December 2018 Release Notes: Web Maintenance
  58. Custom Mail Settings!
  59. November 2018 Release Notes: Platform Maintenance
  60. October 2018 Release Notes: Maintenance
  61. Improved User Management
  62. Views & Quick Filter Updates
  63. July 2018 Release Notes: Maintenance
  64. June 13, 2018 Release Notes: Maintenance
  65. May 25, 2018 Release Notes: Sandbox Environments
  66. May 2018 Release Notes: Deprecating TLS 1.0 & 1.1
  67. April 23rd Release Notes: Maintenance
  68. April 18th Release Notes: Maintenance
  69. April 10th Release Notes: Maintenance
  70. March 2018 Release Notes: Maintenance
  71. February 2018 Release Notes: More Intelligent Saving & Other Notes
  72. January 2018 Release Notes: Maintenance
  73. December 2017 Release Notes: Offline Editing on Android
  74. November 2017 Release Notes: Timeline | Calendar and Conditional Formatting
  75. September 2017 Release Notes: Maintenance
  76. August 2017 Release Notes: Maintenance
  77. July 2017 Release Notes: Maintenance
  78. June 27, 2017: TrackVia Introduces Flows!
  79. May 22, 2017: TrackVia Apple Watch App
  80. May 2017 Release Notes
  81. May 5, 2017: Better Connectivity Handling
  82. April 2017 Release Notes
  83. March 2017 Release Notes
  84. March 27, 2017: Single Sign On
  85. February 23, 2017: Winter Polish
  86. February 2017 Release Notes: Session Timeouts
  87. January 2017 Release Notes: Number Display Options & Min / Max

Feedback and Knowledge Base