Pivot chart showing incorrect values.

[#1]

Hi,

Please find attached and help me as I have to show the 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.

I did pivot chart but it seems the data is not showing correctly. please can anyone let me know how to set this.

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Try these expressions instead:

count({<Details={'Closed','closed'}>}1)

count({<Details={'Future Date'}>}1)

[#3]

Great Gysbert .Thanks and this works perfect.