How to write expression in chart item

[#1]

Hi,

Could any one help me below.

please find attached and I need to show

A chart item which lists each person in the team , and the number of work items they have closed. In addition to that I need a breakdown of the individual work item types each individual closed. For example something as basic as:

Name      Total Work Items closed      Work Item Type              Total

Seanne               3                           Authorised missed payment       2

                                                       PPI                                          1

Please can anyone helpme with chart item ecpressions please.

thanks.

[salto]

Hi Amelia,

not exactly what you asked for attached goes an example.

Regards.

[Anonymous]

Use calculated dimension for the 2nd column - see attached.

(And please reduce the file before uploading next time)

[Or]

Use the following calculated dimension:

=aggr(count(DISTINCT WorkItemType),Name)

[#5]

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

[#6]

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

[#7]

Thanks and sorry I have to show Who instead of Name

Please help me how to change this.

[Anonymous]

Why three times???

the first dimension will be Who, and the 2nd (calculated):

aggr(count(WorkItemType),Who)

[#9]

Thanks and suppose if I want to get these items for

where DateLogged>29/01/2012

how can I give? please help

[ThornOfCrowns]

If you amend the values in your reply from Name to Who, you do not get anything returned in the first column. There's a disjunct between Name and Who, i.e. they aren't linked.

If you look at a preview of the Link Table, you'll see that there are no WorkItems  listed against the "Who" data rows. This is the problem that needs to be addressed, I think. Amelia D