Hi,
I am counting the hits on a website,
each hit has an id and a visit-date.
When I am making a bar chart with the chart expert
saying data: on change of visit date - show: count of id
it works fine,
as a result i get the hits per month beginning
with the month with the most hits (which is no good,
because i want it following: jan,feb,mar,apr,...)
when i say chart expert/layout: on change of @month
(where month is simply month(visit_date)
show: count of id
--> the result shows lesser hits than actually are true!
why does this happen?? it must have the same result but it
hasnt!
and how can i sort the months in the correct order with
the first method on the chart expert?
thanx in advance
chris
I am counting the hits on a website,
each hit has an id and a visit-date.
When I am making a bar chart with the chart expert
saying data: on change of visit date - show: count of id
it works fine,
as a result i get the hits per month beginning
with the month with the most hits (which is no good,
because i want it following: jan,feb,mar,apr,...)
when i say chart expert/layout: on change of @month
(where month is simply month(visit_date)
show: count of id
--> the result shows lesser hits than actually are true!
why does this happen?? it must have the same result but it
hasnt!
and how can i sort the months in the correct order with
the first method on the chart expert?
thanx in advance
chris
