Help in expression

[#1]

Hi,

Could anyone assist me in this please. As I have to show

Future Work Item WIP - essentially a report listing all work items by team which have not yet fallen due but are held in the database.

I did it with Bar chart. But I am not sure whether the way I did and whether the expression is right or not. please find attached.

[Gysbert_Wassenaar · Accepted solution]

Maybe this to count the cases with a due date that lies in the future:

COUNT({<DueDate={'>$(=today())'}>}DISTINCT(CaseID))

[#3]

Thanks and yes you are right. and will it means the cases which have not yet fallen due but are held in the database? is that you mean?

[Gysbert_Wassenaar]

Yes, that's correct.

[#5]

Thanks very much!

[#6]

Can anyone help me as I have problem now. I tried in many ways but not able to find the solution.

I need to show as per below requirement.

Bar chart reflecting issues reaching their due date, to reflect the forthcoming week on the x-axis in the left-most column and the next four weeks across to the right.

Edit: as I already have the items per week. But now I need to show the future weeks data.

Please can anyone suggest me.

[#7]

Please can anyone help me as this is very very urgent

[#8]

Can anyone solve this please

[Gysbert_Wassenaar]

See attached qvw. If that is not what you need, please explain in more detail what the result should look like.

[#10]

Thanks. You craeted one chart item with

Dimesion1: =Weekname(DueDate)

Expression: count({<DueDate={'>=$(=date(today()))<=$(=date(today()+7*$(vWeeks)))'}>}DISTINCT CaseID)

The graph is showing 2014/08, 2014/09, 2014/10, 2014/16, 2014/17, 2014/18, 2014/20 on horizontal axes.

My user is asking to have only that month dates. i,e for march 2014 the weeks are 9,10,11,12. so, they are asking to have only that month weeks i,e 2014/09, 2014/10, 2014/11, 2014/12 . If it crossed match then it showuld show only april 2014 dates. Like this in the future also. But it shouldn't show more than four weeks dates and it shouldn't show completed weeks dates.

Is it possible?