How to get the count?

[#1]

Hi,

Can anyone ;et me know Is it possible to create

How many organisations that I got in that working week and from which organisation the student is came?

Thanks.

[#2]

use a pivot table? bar chart?

[#3]

Thanks and I did the same earlier but no use so I changed to Line. Is there any way to get this. Is the expression is correct which I used?

[amit_saini]

Hi Amelia,

Use Pivot chart and you will be getting desired count the way you want.

Thanks,

[#5]

Thanks and my user wants to see the data in graph.any solution please?

[#6]

well i should use a bar chart then.

You can see count per organization

[amit_saini]

Hi Just give in Expression:

Count(distinct Field)

Thanks,

[#8]

Thanks and I used the same but it is showing very small bars and more bars so the bar is not clear.

I have to show the trends of data. Is it possible with below expression?

avg({<Week={"<=$(Max(Week))"},Week={">$(=max(Week)-1)"}>} StudentID)

[#9]

Any help please?