Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.