How to write expression?

[#1]

Hi,

I have to create a straight table to show

Work Item Due Status (open, closed, in progress) - by team and to include aged analysis, last note and date of last note but only in respect of work items that have fallen due or are overdue.

Please could anyone help me with expression please of how to get above result. I tried but it seems the result is not ok.

Thanks.

[juleshartley]

Do you mean that the table only displays rows where work items are overdue? Or just certain fields are visible based on this?

[#3]

I mean the entire straight table is wrong. because it is not showing values accurate. Please help me how to set this.

[juleshartley]

But can you explain what you want the table to show? Do you just want to show rows where the work item is over due or do you want to show all of the rows, but only certain COLUMNS if it is overdue?

[#5]

I would need to show the workitems like below

e.g.
Team                Open           Closed            Total
Review 
Variations  
IVASTRT  
..  
..  
Total  
 

Then look to introduce the Due Date and a summary of how many issues are within the due date and the number of breaches for each team.  One for open issues and one for closed.

Team          Open   WithinDueDate         BreachedDueDate      OpenTotal
Review  
Variations  
IVASTRT 
..  
..  
Total  
  
                  

Closed  WithinDueDate          BreachedDueDate         ClosedTotal
Review 
Variations  
IVASTRT 
..  
..  
Total  
 

[#6]

Any help please.

[juleshartley]

This, for example, would give you a count of overdue issues across the 'TeamToAddress' dimension:

=

Sum(

Aggr(

     (Count(DISTINCT

     if(Date(DueDate)>Today(), IssueId)

     )

     , TeamToAddress

     )

[#8]

thanks and how can I show how many items open closed and inprogress?

[juleshartley]

That depends on the criteria... but I assume that open, for example, does not have a 'DateIssueResolved', so you would use something like:

Sum(

Aggr(

Count (Distinct

If(isnull(DateIssueResolved), IssueID)

)

,TeamToAddress)

I'm afraid I can't write them all out for you