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
How can I write an expression to satisfy my need from the each date view?
As you see above, Count(if(ISTEK_ACISTARIHI2 >=30,ISTEK_ACISTARIHI2, ISTEK_DURUM='Açık')) wtih this expression , ıt brings total amount 8 but ıt should bring zero since ISTEK_ACISTARIHI2 is not older than 30 days
if ISTEK_ACISTARIHI2 older than 30 days and ISTEK_DURUM ='Açık' , ıt must count total rows both satisfies two conditions