| Aura divider |
|---|
| summary | Timesheets Examples |
|---|
| params | JTdCJTIydHlwZSUyMiUzQSUyMnRleHQlMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhUGFwZXJQbGFuZSUyMiUyQyUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyc2l6ZSUyMiUzQTI0JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZm9udFNpemUlMjIlM0EzMiUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIybGlnaHRlciUyMiUyQyUyMnRleHQlMjIlM0ElMjJUaW1lc2hlZXRzJTIwRXhhbXBsZXMlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJ0b3AlMjIlM0FmYWxzZSUyQyUyMnJpZ2h0JTIyJTNBZmFsc2UlMkMlMjJib3R0b20lMjIlM0F0cnVlJTJDJTIybGVmdCUyMiUzQWZhbHNlJTJDJTIyY29sb3IlMjIlM0ElMjIlMjMzMzMlMjIlMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTdEJTJDJTIyc2l6ZSUyMiUzQSU3QiU3RCU3RCU3RA== |
|---|
|
Image Removed | Aura divider |
|---|
| summary | Aura Divider |
|---|
| params | JTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWJ1c2luZXNzLXRpbWUlMjIlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMnNpemUlMjIlM0ExOCU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMmZvbnRTaXplJTIyJTNBMTQlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmJvbGQlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQXVyYSUyMERpdmlkZXIlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJ0b3AlMjIlM0FmYWxzZSUyQyUyMnJpZ2h0JTIyJTNBZmFsc2UlMkMlMjJib3R0b20lMjIlM0F0cnVlJTJDJTIybGVmdCUyMiUzQWZhbHNlJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMmRhcmslMjIlM0ElMjIlMjNkZGQlMjIlN0QlMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTdEJTJDJTIyc2l6ZSUyMiUzQSU3QiU3RCU3RCU3RA== |
|---|
|
| Table of Contents |
|---|
| minLevel | 2 |
|---|
| maxLevel | 6 |
|---|
| outline | false |
|---|
| type | list |
|---|
| printable | false |
|---|
|
| Aura divider |
|---|
| summary | Aura Divider |
|---|
| params | JTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LWxpbmUlMjIlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMnNpemUlMjIlM0ExOCU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMmZvbnRTaXplJTIyJTNBMTQlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmJvbGQlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQXVyYSUyMERpdmlkZXIlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJ0b3AlMjIlM0FmYWxzZSUyQyUyMnJpZ2h0JTIyJTNBZmFsc2UlMkMlMjJib3R0b20lMjIlM0F0cnVlJTJDJTIybGVmdCUyMiUzQWZhbHNlJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMmRhcmslMjIlM0ElMjIlMjNkZGQlMjIlN0QlMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTdEJTJDJTIyc2l6ZSUyMiUzQSU3QiU3RCU3RCU3RA== |
|---|
|
Team Estimates vs. Actuals
...
Steps to Recreate
Once you’ve set the Source to pull in the desired Jira data, set the Chart bydropdown to be Worklog Author
Navigate to the Calculatedropdown. Switch the first dropdown from Count to Sum, then select Time Spent for the second dropdown
Click the Legend tab on the right side of the chart or macro and click Add Column at the bottom of the section
In the 2 Calculate dropdowns that appear, choose Sum for the first dropdown and Remaining Estimate
...
Optional: Give your chart a title and navigate to the Display Options tab to change the Time Unit (the default is hours)
...
Click Save or Insert
| Aura divider |
|---|
| summary | Aura Divider |
|---|
| params | JTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LWNvbHVtbiUyMiUyQyUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjMzMzMlMjIlMkMlMjJkYXJrJTIyJTNBJTIyJTIzZGRkJTIyJTdEJTJDJTIyc2l6ZSUyMiUzQTE4JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTdCJTIybGlnaHQlMjIlM0ElMjIlMjMzMzMlMjIlMkMlMjJkYXJrJTIyJTNBJTIyJTIzZGRkJTIyJTdEJTJDJTIyZm9udFNpemUlMjIlM0ExNCUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIyYm9sZCUyMiUyQyUyMnRleHQlMjIlM0ElMjJBdXJhJTIwRGl2aWRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQWZhbHNlJTJDJTIycmlnaHQlMjIlM0FmYWxzZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBZmFsc2UlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ3aWR0aCUyMiUzQTElN0QlMkMlMjJzaXplJTIyJTNBJTdCJTdEJTdEJTdE |
|---|
|
Work Logged by Author
...
Steps to Recreate
...
Change the Chart type to Funnel Chart
...
Optional: Give your chart a title and navigate to the Display Options tab to change the Time Unit (the default is hours)
...
Click Save or Insert
| Aura divider |
|---|
| summary | Aura Divider |
|---|
| params | JTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LWxpbmUlMjIlMkMlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMnNpemUlMjIlM0ExOCU3RCUyQyUyMnRleHQlMjIlM0ElN0IlMjJjb2xvciUyMiUzQSU3QiUyMmxpZ2h0JTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZGFyayUyMiUzQSUyMiUyM2RkZCUyMiU3RCUyQyUyMmZvbnRTaXplJTIyJTNBMTQlMkMlMjJ0ZXh0QWxpZ24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyZm9udFdlaWdodCUyMiUzQSUyMmJvbGQlMjIlMkMlMjJ0ZXh0JTIyJTNBJTIyQXVyYSUyMERpdmlkZXIlMjIlN0QlMkMlMjJib3JkZXIlMjIlM0ElN0IlMjJ0b3AlMjIlM0FmYWxzZSUyQyUyMnJpZ2h0JTIyJTNBZmFsc2UlMkMlMjJib3R0b20lMjIlM0F0cnVlJTJDJTIybGVmdCUyMiUzQWZhbHNlJTJDJTIyY29sb3IlMjIlM0ElN0IlMjJsaWdodCUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMmRhcmslMjIlM0ElMjIlMjNkZGQlMjIlN0QlMkMlMjJzdHlsZSUyMiUzQSUyMnNvbGlkJTIyJTJDJTIyd2lkdGglMjIlM0ExJTdEJTJDJTIyc2l6ZSUyMiUzQSU3QiU3RCU3RCU3RA== |
|---|
|
Hours Logged Against Each Customer Account by Month
...
Steps to Recreate
...
for the second dropdown
...
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”)
...
Optional: Give your chart a title and navigate to the Display Options tab to change the Time Unit (the default is hours)
Click Save or Insert
| Aura divider |
|---|
| summary | Aura Divider |
|---|
| params | JTdCJTIydHlwZSUyMiUzQSUyMmljb24lMjIlMkMlMjJzdHlsZSUyMiUzQSU3QiUyMmFsaWdubWVudCUyMiUzQSU3QiUyMmhvcml6b250YWwlMjIlM0ElMjJjZW50ZXIlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIybmFtZSUyMiUzQSUyMmZhLWNoYXJ0LXBpZSUyMiUyQyUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyc2l6ZSUyMiUzQTE4JTdEJTJDJTIydGV4dCUyMiUzQSU3QiUyMmNvbG9yJTIyJTNBJTIyJTIzMzMzJTIyJTJDJTIyZm9udFNpemUlMjIlM0ExNCUyQyUyMnRleHRBbGlnbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJmb250V2VpZ2h0JTIyJTNBJTIyYm9sZCUyMiUyQyUyMnRleHQlMjIlM0ElMjJBdXJhJTIwRGl2aWRlciUyMiU3RCUyQyUyMmJvcmRlciUyMiUzQSU3QiUyMnRvcCUyMiUzQWZhbHNlJTJDJTIycmlnaHQlMjIlM0FmYWxzZSUyQyUyMmJvdHRvbSUyMiUzQXRydWUlMkMlMjJsZWZ0JTIyJTNBZmFsc2UlMkMlMjJjb2xvciUyMiUzQSUyMiUyMzMzMyUyMiUyQyUyMnN0eWxlJTIyJTNBJTIyc29saWQlMjIlMkMlMjJ3aWR0aCUyMiUzQTElN0QlMkMlMjJzaXplJTIyJTNBJTdCJTdEJTdEJTdE |
|---|
|
| Aura inline button |
|---|
| summary | YouTube Tutorials |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJZb3VUdWJlJTIwVHV0b3JpYWxzJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMnNtYWxsJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmYwMDAwJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZjAwMDAlMjIlMkMlMjJvdXRsaW5lJTIyJTNBJTIyJTIzZmYwMDAwJTIyJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJmYS15b3V0dWJlJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRnd3dy55b3V0dWJlLmNvbSUyRiU0ME9sZFN0cmVldFNvbHV0aW9ucyUyMiU3RCU3RA== |
|---|
|
| Aura inline button |
|---|
| summary | Contact Support |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJDb250YWN0JTIwU3VwcG9ydCUyMiUyQyUyMnNpemUlMjIlM0ElMjJzbWFsbCUyMiUyQyUyMnNoYXBlJTIyJTNBJTIyY2lyY3VsYXIlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTdEJTJDJTIyaG92ZXIlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTJDJTIyb3V0bGluZSUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJmYS1xdWVzdGlvbiUyMiU3RCUyQyUyMmxpbmslMjIlM0ElN0IlMjJ0eXBlJTIyJTNBJTIybGluayUyMiUyQyUyMnZhbHVlJTIyJTNBJTIyaHR0cHMlM0ElMkYlMkZ0ZW1wby1pby5hdGxhc3NpYW4ubmV0JTJGc2VydmljZWRlc2slMkZjdXN0b21lciUyRnBvcnRhbCUyRjYlMkZncm91cCUyRjEwNjUlMkZjcmVhdGUlMkY0NSUyMiUyQyUyMnRhcmdldCUyMiUzQSUyMl9ibGFuayUyMiU3RCU3RA== |
|---|
|
| Aura inline button |
|---|
| summary | Marketplace Listing |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJNYXJrZXRwbGFjZSUyMExpc3RpbmclMjIlMkMlMjJzaXplJTIyJTNBJTIyc21hbGwlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMmNpcmN1bGFyJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjM2NTU0YzAlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMm91dGxpbmUlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyMzI2ODRmZiUyMiU3RCU3RCU3RCUyQyUyMmxpbmslMjIlM0ElN0IlMjJ0eXBlJTIyJTNBJTIybGluayUyMiUyQyUyMnZhbHVlJTIyJTNBJTIyaHR0cHMlM0ElMkYlMkZtYXJrZXRwbGFjZS5hdGxhc3NpYW4uY29tJTJGYXBwcyUyRjEyMjA5MjUlMkZjdXN0b20tY2hhcnRzLWZvci1qaXJhLXJlcG9ydHMlM0Zob3N0aW5nJTNEY2xvdWQlMjZ1dG1fdGVybSUzRCUyNnV0bV9jYW1wYWlnbiUzREN1c3RvbSUyQkNoYXJ0cyUyQi0lMkJTZWFyY2glMkJBZHMlMjZ1dG1fc291cmNlJTNEYWR3b3JkcyUyNnV0bV9tZWRpdW0lM0RwcGMlMjZoc2FfYWNjJTNEMzQ1NzMyMzY5NiUyNmhzYV9jYW0lM0QyMDM4NzMxMjQ0JTI2aHNhX2dycCUzRDEyNzgwOTA0NjMxNSUyNmhzYV9hZCUzRDYwMTEzOTAxNTQxNCUyNmhzYV9zcmMlM0RnJTI2aHNhX3RndCUzRGF1ZC05MDA0NTY3ODc0MjAlM0Fkc2EtMTQxNzY3NjAzMjI5NSUyNmhzYV9rdyUzRCUyNmhzYV9tdCUzRCUyNmhzYV9uZXQlM0RhZHdvcmRzJTI2aHNhX3ZlciUzRDMlMjZnY2xpZCUzREVBSWFJUW9iQ2hNSXZ1cm9xY0dEX1FJVlZSUFVBUjA3ZmdRa0VBQVlBU0FBRWdMWkxmRF9Cd0UlMjIlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmZhLWNhcnQtYXJyb3ctZG93biUyMiU3RCU3RA== |
|---|
|
