Expression about date

[QSense]

Hello everyone ,

In my chart ı have two expressions one of them

count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM))  (requests' statu : Open)

second expression

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2)

requests' statu open over 30 days

The problem is with second expression. above formula is working but business side want to see quantityof requests' statu open over 30 days for each week

my date dimension is :

date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')

[QSense]

I wanna make below formula but is not working

=Count({<ISTEK_ACISTARIHI2 = {"<=$(=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') - 30, 'DD.MM.YYYY

hh:mm:ss'))"},ISTEK_DURUM={'Açık'}>} ISTEK_ACISTARIHI2)

[QSense]

In another words for each week

I wanna display both requests' statu : Open and requests' statu open over 30 days

[jagan]

Hi,

Check whether date format is same in ISTEK_ACISTARIHI2 and

=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') - 30, 'DD.MM.YYYY

hh:mm:ss')

expression.

Hope this is the issue.  Is time part exists in ISTEK_ACISTARIHI2 field.

Regards,

Jagan.

[QSense]

date(date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') - 30, 'DD.MM.YYYY hh:mm:ss') format is same with ISTEK_ACISTARIHI2 only formula's time part is seen 00:00:00