I have chart in qvw with StudentID, StaffID, Department, [Exam Date], [Record Date],[No of times Student presence].
the values in column [No of times Student presence] are as shown below
the expression used under [No of times Student presence] is Count(StudentID)
The sample data in chart is as below
|StudentID||StaffID||Department||Exam Date||Record Date||No of times student Presence|
I need to show a pie chart to show the number of times student presence be represented in a graph for example 300 Students, of which 25 are presence to once, 25 are presence to twice and 100 are presence to three times
Please can anyone help me in this.
Have your tried using a calculated dimension like:
=aggr(sum([No of times student Presence]), StudentID)
with the expression
Thanks. the data which I added in my original post is just 11 rows data. But I have millions of data in excel file.
how I need to use Count(StudentID) to show as pie chart
Thanks. you added dimension student presence.
But this student presence have values which is getting from below expression.
so, my requirement is dimension and expression both are same.
is it possible to use expression count(StudentID) for both Dimension and Expression.
Please help me. when I am trying I am not getting exact solution.