Aggregating data?

[#1]

Hopefully this is a fairly simple one:

I am making a simple bar chart on my dashboard that is showing coursecreatedates vs. course revenue. The problem I am having is that the chart is showing one bar per each course creation and not, as i want, one bar per date summing/ aggregating the revenue for each day;

e.g.  currently; 5 bars of £Xk on 05/12/2011, instead of £5Xk on 05/12/2011.

Is this just a simple aggregation forumula that i need to add as a calculated dimension?? I have a fairly long expression that calculates the course revenue which may be complicating things.

Would be grateful if someone can give me a nudge in the right direction.

Thanks.

[swuehl · Accepted solution]

Could it be that your are using a timestamp as creation date (even if formatted as Date without time)?

Try a

=daystart(coursecreationdate)

as dimension.

If this works, you could change the timestamp to date in your script also.

Hope this helps,

Stefan

[#3]

Just the job. Thanks for your help Stefan.

Much appreciated,

Laurence