Forum Discussion

Doug Works's avatar
Doug Works
Copper Contributor
May 09, 2018

Problem developing graph

I'm not sure if I need to use something other than a pivot table to get what I want from this data.

 

Data:

 

ID,Software,Date Purchased,Type,Age
1,Access,5/9/2018,Database, 1 2,Excel,5/7/2018,Spreadsheet, 2 3,Access,5/3/2018,Database, 6 4,Minecraft,4/14/2018,Game, 25 5,SQL Server,4/28/2018,Database, 11 6,Excel,5/6/2018,Spreadsheet,3 7,SQL Server,5/7/2018,Database, 2 8,Excel,5/1/2018,Spreadsheet,8 9,SQL Server,5/9/2018,Database, 1 10,Minecraft,5/1/2018,Game,8

 

I can display the average and max values of my raw data. I can also show the "count" of the different "types" of software.





What I *want* to show, each with a separate line, is:

* Average Age
* Max Age
* Number of Database items
* Number of Spreadsheet items


(Note: items 3 and 4 are combined in the grey line above... plus there is another category ("game") that is included in the gray line that I do not want to show up.)

Please help? Thanks.

No RepliesBe the first to reply

Resources