Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Once you’ve set the Source to pull in the desired Jira data, set the Chart bydropdown to be Worklog Author

  2. Navigate to the Calculatedropdown. Switch the first dropdown from Count to Sum, then select Time Spent for the second dropdown

  3. Click the Legend tab on the right side of the chart or macro and click Add Column at the bottom of the section

  4. In the 2 Calculate dropdowns that appear, choose Sum for the first dropdown and Remaining Estimate for the second dropdown

  5. Optional: Give your chart a title and navigate to the Display Options tab to change the Time Unit (the default is hours)

  6. Click Save or Insert

Aura divider
summaryAura Divider
paramsJTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LWNvbHVtbiUyMiUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjMzMzMlMjIlMkMlMjJkYXJrJTIyJTNBJTIyJTIzZGRkJTIyJTdEJTJDJTIyc2l6ZSUyMiUzQTE4JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjMzMzMlMjIlMkMlMjJkYXJrJTIyJTNBJTIyJTIzZGRkJTIyJTdEJTJDJTIyZm9udFNpemUlMjIlM0ExNCUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIyYm9sZCUyMiUyQyUyMnRleHQlMjIlM0ElMjJBdXJhJTIwRGl2aWRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQWZhbHNlJTJDJTIycmlnaHQlMjIlM0FmYWxzZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBZmFsc2UlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ3aWR0aCUyMiUzQTElN0QlMkMlMjJzaXplJTIyJTNBJTdCJTdEJTdEJTdE

Work Logged by Author

...

Steps to Recreate

  1. Once you’ve set the Source to pull in the desired Jira data, set the Chart bydropdown to be Worklog AuthorNavigate to the Calculatedropdown. Switch the first dropdown from Count to Sum, then select Time Spent for the second dropdown

  2. Change the Chart type to Funnel Chart

  3. Optional: Give your chart a title and navigate to the Display Options tab to change the Time Unit (the default is hours)

  4. Click Save or Insert

Aura divider
summaryAura Divider
paramsJTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LWxpbmUlMjIlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMnNpemUlMjIlM0ExOCU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMmZvbnRTaXplJTIyJTNBMTQlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmJvbGQlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQXVyYSUyMERpdmlkZXIlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJ0b3AlMjIlM0FmYWxzZSUyQyUyMnJpZ2h0JTIyJTNBZmFsc2UlMkMlMjJib3R0b20lMjIlM0F0cnVlJTJDJTIybGVmdCUyMiUzQWZhbHNlJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMmRhcmslMjIlM0ElMjIlMjNkZGQlMjIlN0QlMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTdEJTJDJTIyc2l6ZSUyMiUzQSU3QiU3RCU3RCU3RA==

Hours Logged Against Each Customer Account by Month

...

Steps to Recreate

    Once you’ve set the Source to pull in the desired Jira data, set the Chart bydropdown to be AccountNavigate to the Calculatedropdown. Switch the first dropdown from Count to Sum, then select Time Spent for the second dropdown
  1. In the Chart by tab, click the Grouping dropdown and choose Months. You can also click into the Range dropdown to set the span of dates (i.e “This Quarter”)

  2. Change the Chart Type to Tile Chart

  3. Optional: Give your chart a title and navigate to the Display Options tab to change the Time Unit (the default is hours)

  4. Click Save or Insert

Aura divider
summaryAura Divider
paramsJTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LXBpZSUyMiUyQyUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyc2l6ZSUyMiUzQTE4JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZm9udFNpemUlMjIlM0ExNCUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIyYm9sZCUyMiUyQyUyMnRleHQlMjIlM0ElMjJBdXJhJTIwRGl2aWRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQWZhbHNlJTJDJTIycmlnaHQlMjIlM0FmYWxzZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBZmFsc2UlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ3aWR0aCUyMiUzQTElN0QlMkMlMjJzaXplJTIyJTNBJTdCJTdEJTdEJTdE

Aura inline button
summaryYouTube Tutorials
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJZb3VUdWJlJTIwVHV0b3JpYWxzJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMnNtYWxsJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmYwMDAwJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZjAwMDAlMjIlMkMlMjJvdXRsaW5lJTIyJTNBJTIyJTIzZmYwMDAwJTIyJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJmYS15b3V0dWJlJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRnd3dy55b3V0dWJlLmNvbSUyRiU0ME9sZFN0cmVldFNvbHV0aW9ucyUyMiU3RCU3RA==
Aura inline button
summaryContact Support
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJDb250YWN0JTIwU3VwcG9ydCUyMiUyQyUyMnNpemUlMjIlM0ElMjJzbWFsbCUyMiUyQyUyMnNoYXBlJTIyJTNBJTIyY2lyY3VsYXIlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIyb3V0bGluZSUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJmYS1xdWVzdGlvbiUyMiU3RCUyQyUyMmxpbmslMjIlM0ElN0IlMjJ0eXBlJTIyJTNBJTIybGluayUyMiUyQyUyMnZhbHVlJTIyJTNBJTIyaHR0cHMlM0ElMkYlMkZ0ZW1wby1pby5hdGxhc3NpYW4ubmV0JTJGc2VydmljZWRlc2slMkZjdXN0b21lciUyRnBvcnRhbCUyRjYlMkZncm91cCUyRjEwNjUlMkZjcmVhdGUlMkY0NSUyMiUyQyUyMnRhcmdldCUyMiUzQSUyMl9ibGFuayUyMiU3RCU3RA==
Aura inline button
summaryMarketplace Listing
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJNYXJrZXRwbGFjZSUyMExpc3RpbmclMjIlMkMlMjJzaXplJTIyJTNBJTIyc21hbGwlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMmNpcmN1bGFyJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjM2NTU0YzAlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMm91dGxpbmUlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyMzI2ODRmZiUyMiU3RCU3RCU3RCUyQyUyMmxpbmslMjIlM0ElN0IlMjJ0eXBlJTIyJTNBJTIybGluayUyMiUyQyUyMnZhbHVlJTIyJTNBJTIyaHR0cHMlM0ElMkYlMkZtYXJrZXRwbGFjZS5hdGxhc3NpYW4uY29tJTJGYXBwcyUyRjEyMjA5MjUlMkZjdXN0b20tY2hhcnRzLWZvci1qaXJhLXJlcG9ydHMlM0Zob3N0aW5nJTNEY2xvdWQlMjZ1dG1fdGVybSUzRCUyNnV0bV9jYW1wYWlnbiUzREN1c3RvbSUyQkNoYXJ0cyUyQi0lMkJTZWFyY2glMkJBZHMlMjZ1dG1fc291cmNlJTNEYWR3b3JkcyUyNnV0bV9tZWRpdW0lM0RwcGMlMjZoc2FfYWNjJTNEMzQ1NzMyMzY5NiUyNmhzYV9jYW0lM0QyMDM4NzMxMjQ0JTI2aHNhX2dycCUzRDEyNzgwOTA0NjMxNSUyNmhzYV9hZCUzRDYwMTEzOTAxNTQxNCUyNmhzYV9zcmMlM0RnJTI2aHNhX3RndCUzRGF1ZC05MDA0NTY3ODc0MjAlM0Fkc2EtMTQxNzY3NjAzMjI5NSUyNmhzYV9rdyUzRCUyNmhzYV9tdCUzRCUyNmhzYV9uZXQlM0RhZHdvcmRzJTI2aHNhX3ZlciUzRDMlMjZnY2xpZCUzREVBSWFJUW9iQ2hNSXZ1cm9xY0dEX1FJVlZSUFVBUjA3ZmdRa0VBQVlBU0FBRWdMWkxmRF9Cd0UlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmZhLWNhcnQtYXJyb3ctZG93biUyMiU3RCU3RA==

...