Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have to fields ISTEK_DURUM and ISTEK_ACILISTARIHI
ı have get data where ISTEK_DURUM='Açık' and ISTEK AÇILIS_TARIHI older than 30 days ago
hello,
Try this
load *
resident TABLE_NAME where wildmatch(ISTEK_DURUM,'Açık')>0 and AÇILIS_TARIHI<date(today()-30);
Thanks for reply
not today -30 I want to get 30 days older than AÇILIS_TARIHI
Try
date(num(AÇILIS_TARIHI)-30)
=date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY') my dimension date in chart
my dimension - 30 all ı want
Below expression calculates from today not ISTEK_ACISTARIHI2
=Count({<ISTEK_ACISTARIHI2 = {"<=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2)