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.

[giakoum]

if x axis is week, then that is what it should be showing

count of organisation for each week you asked for. Just order week correctly. if your data expands multiple years, then maybe you should use year_week instead of week only.

[#3]

How can I show year_week?

[giakoum]

you have WeekYear in your calendar...

[#5]

ok yes I have and I used the same and again the same layout showing. Is there any other way I can display this in very visual manner?

[giakoum]

try from the available chart types and determine based on your needs. A stacked bar chart would also be a good choice. Try, practice makes perfect

[#7]

Thanks and if I want to show the trends of weeks data will the below expression work?

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

[giakoum]

did you try it? You cannot compare month with week. But anyway, I would use trendlines instead. It is a built in functionality.

[#9]

Could I know what is the difference as I haven't observed any difference after using this.

[giakoum]

you most likely are not using it correctly. See the manual for more help on the topic.

See also attached example, but it will not help unless you read the theory behind it first.

[#11]

Thanks. Yes I can able to see the differences as when I made exponential and there is a line showing at 1.0. But i am worrying only with the layout of the chart item.