Help needed in writing function ?

[santho_ak]

I need a help in writing a function. For example, this is my table which I took from SQL database.

Candidate Status	Candidate id
Selected	05
Rejected	03
Rejected	07
Rejected	02

I want to show a chart which should say number of candidates rejected & number of employees selected. Help me out.Thanks. Can someone explain with chart. Thanks

[felipedl]

Hi Santosh,

After you load the data, you can use set analysis to check the both measures you want, something like.

// For the selected candidates

count({<[Candidate Status]={'Selected'}>}[Candidate id])

// For the selected candidates

count({<[Candidate Status]={'Rejected'}>}[Candidate id])

The bolded part is the set analysis and will segment your data as stated on the equality.

Felipe.