21 Replies Latest reply: Nov 19, 2012 1:09 PM by ahnet ceylan

Set analysis

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))

• Re: Set analysis

Hi

I am afraid your query does not appear to make sense to me, but assuming I understand what you need correctly, try this

=Count({<ISTEK_ACISTARIHI2 = {"<=\$(=Date(Today() - 30))"}>} ISTEK_ACISTARIHI2)

+Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

Hope that helps

Jonathan

• Re: Set analysis

It didnt work

your query get same result with the Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM) query

I want to show both data's status 'Açık' and data's created date older than 30 days

in my example data with ISTEK_DURUM='Açık' =450 and

data created date older than 30 days (Count(if(today()-30 >=ISTEK_ACISTARIHI2,ISTEK_ACISTARIHI2))  =  264

• Re: Set analysis

Hi

The expression assumes that ISTEK_ACISTARIHI2 is in the default date format for your system (for example YYYY/MM/DD or MM/DD/YYYY). If it is in a different format, then change the expression to explicitly format the date to match the format of ISTEK_ACISTARIHI2:

=Count({<ISTEK_ACISTARIHI2 = {"<=\$(=Date(Today() - 30, 'DD/MM/YYYY'))"}>} ISTEK_ACISTARIHI2)

+Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

• Re: Set analysis

Try this,

Regards,

Kaushik Solanki

• Re: Set analysis

It didnt work

• Re: Set analysis

HI,

Could you please send us sample file with few records.

Regards,

Kaushik Solanki

• Re: Set analysis

Hi,

What I mean is that there are two columns above pointed with red 'Açılış_tarihi' and 'Durum'

Açılış_tarihi = ISTEK_ACISTARIHI2 and Durum=ISTEK_DURUM

I wanna to see both Açılış_tarihi  older than 30 days and durum='Açık'

İn the picture ,in below part there are two numbers 415 equals ISTEK_DURUM='Açık'

ISTEK_ACISTARIHI2 older than 30 days and Istek_durum='Açık' equals 264

• Re: Set analysis

So you want two expressions, like this?

=Count({<ISTEK_ACISTARIHI2 = {"<=\$(=Date(Today() - 30, 'DD/MM/YYYY'))"}>} ISTEK_ACISTARIHI2)

=Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

Regards

Jonathan

• Re: Set analysis

Correction - like this:

=Count({<ISTEK_ACISTARIHI2 = {"<=\$(=Date(Today() - 30, 'DD/MM/YYYY'))"}, ISTEK_DURUM={'Açik'}>} ISTEK_ACISTARIHI2)

=Count({<ISTEK_DURUM={'Açik'}>} ISTEK_DURUM)

Regards

Jonathan

• Re: Set analysis

As you see, One of your expression works ISTEK_DURUM='Açık' 415

Other expression didnt work

• Re: Set analysis

In what way did it not work? That way we dont have to guess the problem.

• Re: Set analysis

I think the date format is the problem, as stated in earlier posts. From your screen shot, looks like the date format of ISTEK_ACISTARIHI2 is a timestamp. You will need to match that in the Date() statement in the set expression - perhaps:

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

Jonathan

• Re: Set analysis

Hi Jonathan,

As you said my date format DD.MM.YYYY hh:mm:ss

but I wanna two condistion must be satisfied. both 'Açık' and older than 30 days

• Re: Set analysis

İf you want to see,

I will attach a simple file

Thanks for replies.

• Re: Set analysis

Without click for Durum='Açık'I want to see result both satisfies DURUM='AÇIK' and older than 30 days

• Re: Set analysis

HI

Try like this

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

Hope that helps

• Re: Set analysis

Thats what that expression does. you just need to align the data format in the Date() statement with the format of ISTEK_ACISTARIHI2

• Re: Set analysis

Hi Jonathan and MAyil ,

Thank you for replies

• Re: Set analysis
 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?