How to get correct data?

[#1]

Hi,

Is it possible to create

1) How many organisations there are per week?

2) Organisation split per week?

I tried but it seems I have doubt on result. Please help with correct expressions?

Thanks.

[#2]

Do I need to use Count(Distinct(organisation)) instead of Count(Distinct(StudentID))

[giakoum]

yes you should, and week as dimension and not organisation.

You also have time in your date field, so you need to ceil it for example to get rid of time. That is why your date field does not match the calender date you are using.

[#4]

Thanks. If I want to show the  information in table and graph means. could you suggets will Pivot and Bar suits or Pivot and Line chart?

[giakoum]

Bar chart sort by count organisation desc would be my choice

[#6]

Thakns. Actually I have to show

a)No of organisations per week

b) organisation split per week

If I want to display organisation on vertical axis how can I do this?

[giakoum]

try a grid chart with wee, organisation as dimensions and Count(Distinct(organisation)) as expression. For the organisation split per week, maybe a stacked bar chart would be a good choice.

[#8]

Thanks. That means do Ineed to do two charts. If so will the  dimensions and expressions are same for two charts?

[giakoum]

Depending on your customer needs, yes it will be 2 charts. Expression may be the same, just tick relative in the split one. But you need to try it out yourself and decide what suits your needs.

[#10]

please find attached when i use grid chart it is showing ...