support@vertica-digital.com (+420) 775 439 123

Advanced analytics





Sum up data using Bar chart gadget

Create tables containing data with multiple statistics. With this functionality, you can analyse whatever you need to.

Table report screen

Typical usage of the Bar chart is to view progressive statistics over a time period, so that you can check whether the trend of the data is desired, or not (increase, decrease or stabilization). Such example could be summing up amount of Story Points burnt per Sprint, count of items aiming for a certain release, or count of different work items in your product backlog. You can also compare how many Story points there are in each release – to prevent snowball effect (increasing load in each release), to ensure you’re still building an MVP.



Configuration

  1. Go to dashboard on which you're willing to place the Gadget
  2. Add Gadget called "Advanced Analytics table (filter/SQL)" to the dashboard
  3. Dashboard item screen

  4. Fill in the details on the gadget configuration screen
  5. Report gadget configuration
    • Saved filter (optional)
    • JQL - select data you want to show in the table
    • Fields to sum - select data to sum up
    • Rows values from - select data to be shown on the y axis (vertical)
    • Columns values from - select data to be shown on the x axis (horizontal)

    4. Click on button "Save" and now you see statistics you wanted :)