Report to show tickets by week for 6 months

[Aman-K]

Hi All,

I am new to Power BI and trying to create a report that will show me number of tickets by Week (Last 6 months)

1. Created period of 6 months (Weekly)
2. Completed period of 6 months (Weekly)

SImilar to the below report :

Tickets by week for 6 months 

Hope to hear any solutions from you soon.

Thanks

[vanessafvg]

you need to provide sample data, with an example of your expected solution.

[Aman-K]

Hi @vanessafvg 

I have got all data from Jira using Rest API. It has issueID,IssueKey,DateCreated,Status,ResolutionDate,IssueType etc.. fields . I want a line graph that will show me total issues by week for 6 months . Please see attached the document with the expected report. 

Thanks 

[vanessafvg]

 if you want someone to help, you need to provide sample data.  

please read the following post to get an understanding of what you need to provide.  Make up some dummy data if you can't share.  The onus is on you to provide it if you need assistance.

please read this post to understand the importance of it.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/3034626#M1032...

[Aman-K]

Thanks @vanessafvg , Please see below the data. 

IssueId

IssueKey

Reporter?

IssueLastViewed

IssueType

AggregateTimeSpent

Workratio

ReporterName

IsReporterActive

WatchCount

IsWatching

UpdateDate

Channel

PriorityName

Priority.Id

Delete-StatusDescription

Delete-StatusName

Delete-StatusId

Delete-StatusCategory-1

Delete-StatusCategory.ColorName

Delete-StatusCategory.Name

Delete-Priority.Name

Delete-priority.id

DueDate

Status

Status.Id

StatusCategoryKey

StatusCategoryColorName

StatusCategoryName

issues.fields.aggregatetimeestimate

CreatorName

IsCreatorActive

IssueTimeSpent

issues.fields.customfield_10311.value

System Name

ProjectKey

ProjectName

issues.fields.project.projectTypeKey

issues.fields.customfield_10006

IssueSummary

RAG

AssigneeName

ResolutionDesc

ResolutionName

TicketType

ProjectFundingOrNo

Impact(L/M/H)

ResolutionDate

ResolutionTime

IssueDateCreated

IssueTimeCreated

1066313

DDASEAU-427

Sims, Aaron

Sub-task

-1

Sims, Aaron

TRUE

1

FALSE

2023-03-15T16:38:53.000+0000

UXP Channel

Medium

3

This issue is being actively worked on at the moment by the assignee.

In Progress

3

indeterminate

yellow

In Progress

High

2

In Progress

4

indeterminate

yellow

In Progress

Sims, Aaron

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Investigate boi-media options

GREEN

Sims, Aaron

########

11:32:02

1064980

DDASEAU-425

Hammond, David

Initiative

-1

Hammond, David

TRUE

1

FALSE

2023-02-15T16:05:24.000+0000

UXP Channel

High

2

In Progress

4

indeterminate

yellow

In Progress

0

Hammond, David

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Retire / replace boi-media.co.uk - Q1

Sims, Aaron

Support

Moderate

########

10:52:21

978182

DDASEAU-422

Baines, Adrian

Initiative

-1

Baines, Adrian

TRUE

1

FALSE

2023-01-26T11:22:11.000+0000

UXP Channel

Medium

3

To Do

2

new

blue-gray

To Do

Baines, Adrian

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Workflow management tool

Hammond, David

Requirement

Project Funding

Moderate

28-Oct-22

12:21:46

968879

DDASEAU-419

Hammond, David

Initiative

-1

Hammond, David

TRUE

2

FALSE

2023-01-26T11:17:58.000+0000

UXP Channel

Medium

3

To Do

2

new

blue-gray

To Do

Hammond, David

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

UK Screen Reader Compatability

Hammond, David

Requirement

No Funding

18-Oct-22

15:04:43

942335

DDASEAU-409

Gray, Matthew

Epic

-1

Gray, Matthew

TRUE

2

FALSE

2022-09-21T16:35:58.000+0100

UXP Channel

Low

4

To Do

2

new

blue-gray

To Do

Shaw, Kevin

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

I&E Importing Investigation

Hammond, David

Incident

########

16:35:21

937498

DDASEAU-406

Percy, Jonathon

Epic

-1

Percy, Jonathon

TRUE

1

FALSE

2022-10-06T15:03:26.000+0100

UXP Channel

Medium

3

To Do

2

new

blue-gray

To Do

Percy, Jonathon

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Configuration Document for RMS NI

Percy, Jonathon

########

14:10:39

933284

DDASEAU-402

Moore, Jonathan

Epic

-1

Moore, Jonathan

TRUE

3

FALSE

2022-09-12T13:18:38.000+0100

UXP Channel

High

2

To Do

2

new

blue-gray

To Do

Shaw, Kevin

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Interest Only Concession Prompt Failure

Hammond, David

Incident

########

13:04:31

922529

DDASEAU-399

Blanchard, Stella

Epic

-1

Blanchard, Stella

TRUE

1

FALSE

2022-11-29T12:32:35.000+0000

UXP Channel

High

2

To Do

2

new

blue-gray

To Do

Shaw, Kevin

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Vulnerable customer letter changes

Requirement

Project Funding

########

15:08:35

922527

DDASEAU-398

Blanchard, Stella

Epic

-1

Blanchard, Stella

TRUE

2

FALSE

2022-11-29T12:32:00.000+0000

UXP Channel

Medium

3

To Do

2

new

blue-gray

To Do

Shaw, Kevin

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Pre-arrears process - Visual Files

Requirement

Project Funding

########

15:06:37

922525

DDASEAU-397

Gray, Matthew

Epic

-1

Gray, Matthew

TRUE

1

FALSE

2022-09-05T15:10:36.000+0100

UXP Channel

Medium

3

To Do

2

new

blue-gray

To Do

Shaw, Kevin

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Further "New Arrears Detected (No Queue Change)" schedule items being generated on cases

Arkinstall, Phillip [X]

Incident

########

15:01:44

908296

DDASEAU-395

Gray, Matthew

Epic

-1

Gray, Matthew

TRUE

2

FALSE

2022-09-14T10:09:57.000+0100

UXP Channel

Medium

3

In Progress

4

indeterminate

yellow

In Progress

Shaw, Kevin

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

Removal of £25.00 Continual Default, £50.00 Ground Rent/Service Charge, £75.00 Legal Referral fees from Visualfiles

Shaw, Kevin

Requirement

Project Funding

########

18:36:02

908294

DDASEAU-394

Blanchard, Stella

Epic

-1

Blanchard, Stella

TRUE

2

FALSE

2022-09-12T17:04:31.000+0100

UXP Channel

High

2

In Test

4

indeterminate

yellow

In Progress

Shaw, Kevin

TRUE

Low

DDASEAU

DDAS - UK Digital Delivery

software

PACMAN changes required - uplift to standard financial statement & ONS figures

Shaw, Kevin

Requirement

Project Funding

########

18:31:49