Individual Status

[Anonymous]

Hi Experts,

I have student score card like this

Student ID	Maths
1	Pass
2	Fail
3	Pass
4	Pass
5	Pass
6	Pass
7	Fail
8	Pass
9	Fail
10	Pass

My required output is

Status	Count
Pass	7
Fail	3

Thank you in Advance!!

[arasantorule]

Hi,

Please refer the attached.

Dimension : Maths

Expression: Count([Student ID])

Thanks.

[engishfaque]

Dear Anil,

Kindly find attached file, I hope you are looking for that one.

Kind regards,

Ishfaque Ahmed

[tamilarasu]

Check the attachment.

Data:

Load Distinct Maths,

Count([Student ID]) as Count

Group by Maths;

LOAD * INLINE [

Student ID, Maths

    1, Pass

    2, Fail

    3, Pass

    4, Pass

    5, Pass

    6, Pass

    7, Fail

    8, Pass

    9, Fail

    10, Pass

];

[senpradip007]

Have a look at this.

[Anonymous]

Hi,

I am using personal edition, could you please paste the expression

Thank you,

[Anonymous]

Hi,

I am using personal edition, could you please paste the expression

Thank You,

[tamilarasu]

Or simply load the data and create a straight / pivot table. Maths field as dimension and Count([Student ID]) as expression.

[raju_insights]

Status:

Load Maths as Status,

Count([Student ID]) as Count

Group by Maths;

LOAD * INLINE [

Student ID, Maths

    1, Pass

    2, Fail

    3, Pass

    4, Pass

    5, Pass

    6, Pass

    7, Fail

    8, Pass

    9, Fail

    10, Pass

];

[engishfaque]

Dear Anil,

Here is data model and expression,

Data Model:

--

StudentGrades:

LOAD * Inline [

Student ID, Maths

1, Pass

2, Fail

3, Pass

4, Pass

5, Pass

6, Pass

7, Fail

8, Pass

9, Fail

10, Pass

];

Expression:

--

=Count ({<Maths = {'Pass'}>} [Student ID])

=Count ({<Maths = {'Fail'}>} [Student ID])

For more, please check attached screenshots.

Kind regards,

Ishfaque Ahmed