SOLVED

Need dashboard for Resolved VS Created Tickets.

%3CLINGO-SUB%20id%3D%22lingo-sub-1851816%22%20slang%3D%22en-US%22%3ENeed%20dashboard%20for%20Resolved%20VS%20Created%20Tickets.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1851816%22%20slang%3D%22en-US%22%3E%3CP%3EFollowing%20is%20my%20snippet%20data%20for%20creating%20the%20dashboard.%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2231.578947368421055%25%22%3ETicket%20ID%3C%2FTD%3E%3CTD%20width%3D%2235.08771929824562%25%22%3ECreated%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EStatus%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2231.578947368421055%25%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2235.08771929824562%25%22%3E11%2F03%2F2020%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EClosed%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2231.578947368421055%25%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2235.08771929824562%25%22%3E11%2F01%2F2020%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3ETo%20Do%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2231.578947368421055%25%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2235.08771929824562%25%22%3E10%2F28%2F2020%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EIn%20Progress%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2231.578947368421055%25%22%3E4%3C%2FTD%3E%3CTD%20width%3D%2235.08771929824562%25%22%3E10%2F25%2F2020%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3EClosed%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EI%20would%20like%20to%20create%20the%20dashboard%3A%20Created%20VS%20Resolved.%20I%20am%20looking%20for%20something%20like%20this.%20(Image%20Attached)%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JayJoshi_0-1604464991028.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231347iC71553DC2A97CAA9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JayJoshi_0-1604464991028.png%22%20alt%3D%22JayJoshi_0-1604464991028.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20tried%20but%20could%20not%20get%20the%20solution.%20Can%20anyone%20please%20help%20me%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1851816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1852190%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20dashboard%20for%20Resolved%20VS%20Created%20Tickets.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1852190%22%20slang%3D%22en-US%22%3EYou%20need%20one%20more%20Column%20for%20Dates%20named%20as%20Resolved..%20it's%20like%20created%20on%2001%2F01%2F2020%20and%20resolved%20or%20closed%20on%2001%2F10%2F2020.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1852371%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20dashboard%20for%20Resolved%20VS%20Created%20Tickets.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1852371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F853217%22%20target%3D%22_blank%22%3E%40JayJoshi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EYou%20may%20try%20this%3A%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1604482522237.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231371iCA4662D8086950C7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rajesh-S_0-1604482522237.png%22%20alt%3D%22Rajesh-S_0-1604482522237.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EHow%20it%20works%3A%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3ECreate%20Pivot%20Ta%3CSPAN%3Eb%3C%2FSPAN%3Ele.%26nbsp%3B%3C%2FLI%3E%3CLI%3EKeep%20Date%20in%20ROW%2C%20Details%20in%20COLUMN%20and%20Ticket%20in%20VALUE%20and%20set%20COUNT%20for%20Ticket.%3C%2FLI%3E%3CLI%3ESelect%20PT%20now%20from%20Design%2C%20then%20Layout%20%26amp%3B%20hit%20Grad%20Total%2C%20and%20click%20on%20for%20column%20only.%3C%2FLI%3E%3CLI%3EThen%20Create%20a%20Line%20Chart.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1604483046657.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231375i9335A74E705DC3BF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rajesh-S_0-1604483046657.png%22%20alt%3D%22Rajesh-S_0-1604483046657.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ENote%3A%3C%2FSTRONG%3E%20Working%20with%20PT%20is%20a%20wise%20way%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1852769%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20dashboard%20for%20Resolved%20VS%20Created%20Tickets.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1852769%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F93699%22%20target%3D%22_blank%22%3E%40Rajesh-S%3C%2FA%3E%26nbsp%3B%20Thank%20you%20so%20much.%20You%20are%20miracle%20Excel%20Expert.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Following is my snippet data for creating the dashboard. 

Ticket IDCreatedStatus
111/03/2020Closed
211/01/2020To Do
310/28/2020In Progress
410/25/2020Closed

I would like to create the dashboard: Created VS Resolved. I am looking for something like this. (Image Attached) 

JayJoshi_0-1604464991028.png

 

I really tried but could not get the solution. Can anyone please help me this?

 

 

@Rajesh-S 

4 Replies
You need one more Column for Dates named as Resolved.. it's like created on 01/01/2020 and resolved or closed on 01/10/2020.
best response confirmed by JayJoshi (Occasional Contributor)
Solution

@JayJoshi 

You may try this:

 

Rajesh-S_0-1604482522237.png

 

How it works:

  1. Create Pivot Table. 
  2. Keep Date in ROW, Details in COLUMN and Ticket in VALUE and set COUNT for Ticket.
  3. Select PT now from Design, then Layout & hit Grad Total, and click on for column only.
  4. Then Create a Line Chart.

Rajesh-S_0-1604483046657.png

 

Note: Working with PT is a wise way to do this.

 

@Rajesh-S  Thank you so much. You are miracle Excel Expert.

Glad to help you @JayJoshi ,,, keep asking ☺