Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
Dimension: Applications
Expression: Count({<[Application Status] = {'Approved', 'Declined', 'Processed'}>} Applications)
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
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.