İn my qw ,
I wanto to create second expression
İt must include ISTEK_DURUM='Açık' and ISTEK_AÇISTARIHI2 older than 30 days before selected ISTEK_ACISTARIHI2
when I select ISTEK_DURUM as 'Açık' and date older than 30 days from ISTEK_ACISTARIHI2 it must count affected rows
| =date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') | ISTEK_DURUM |
| 19.11.2012 | Açık | Dimension | =date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') |
| 12.11.2012 | Açık |
| 05.11.2012 | Kapalı |
| 29.10.2012 | Açık |
| 22.10.2012 | Kapalı |
| 15.10.2012 | Açık |
| 08.10.2012 | Açık |
| 01.10.2012 | Açık |
I can explain in sample.
In list above I want to display in chart and my dimension as you see.
but my need is that When I looked in 05.11.2012 date I want to display 30 days and older before 05.11.2012 date and ISTEK_DURUM="Açık"
For each date I would like to see this information
For instance from the wiew of 19.11.2012 how many request satisfy my need
these three rows satsify my need
| 15.10.2012 | Açık |
| 08.10.2012 | Açık |
| 01.10.2012 | Açık |
