Set analysis

[nareshthavidishetty]

I have a field Application status which defines Approved,Declined and processed and application count

May i know how to write an set analysis to get number of applications Approved,Declined and processed.

[sunny_talwar]

May be this:

Dimension: Applications

Expression: Count({<[Application Status] = {'Approved', 'Declined', 'Processed'}>} Applications)

[engishfaque]

Dear Naresh,

Here are the expressions,

Expression 1 : Count Approved Application

Count({<[Application status] = {'Approved'}>} applications)

Expression 2 : Count Declined Application

Count({<[Application status] = {'Declined'}>} applications)

Expression 3 : Count Processed Application

Count({<[Application status] = {'Processed'}>} applications)

Kind regards,

Ishfaque Ahmed

[jagan]

HI,

Try like this

Dimension: Applications

Expression: Count(Applications)

Or if you want to calculate it individually then use below expressions

Approved Applications Expression: Count({<[Application Status] = {'Approved'}>} Applications)

Declined Applications Expression: Count({<[Application Status] = {'Declined'}>} Applications)

Processed Applications Expression: Count({<[Application Status] = {'Processed'}>} Applications)

Hope this helps you.

Regards,

Jagan.