Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i want to count the projects whose status are "open"
but i want to count only for month back from every week start
for example 12.11.2012 is my week start so iwant to count all "open" projects until 12.10.2012
then the same process for 05.11.2012
and the same process for all weeks
thanks a lot
Hi,
This is the condition where you can select a date and based on your selection it will look from the last month and before values and it will provide the report.
If you are specific to open projects, then add the status in you set analysis as open.
Count({<Date={"<=$(=AddMonths(Date,-1))"}>} Date)
Thanks,
Srini.
thanks Srini
but there wont be any selection
on a bar chart i will show every week start
Ok, then add Max on top of the week start date and add the addmonths function.
=AddMonths(Max(WeekStart(Date)),-1)
Thanks,
Srini.