Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a condition that get data older than 30 days and data's ISTEK_DURUM='Açık'
When ı enter below expression I can not take result
How can ı do this with set analysis
=Count(if(today()-30 >=ISTEK_ACISTARIHI2,ISTEK_ACISTARIHI2)and if(ISTEK_DURUM='Açık',ISTEK_DURUM))
Hi Jonathan and MAyil ,
Thank you for replies
Hi Mayil, Thanks for reply but how can I do below case? =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 |
Hello everyone,
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 |
How can I write an expression to satisfy my need from the each date view?