Charting Question

[brad]

I have been trying to figure this out all day. I have a table with a timestamp field in it. What I want to achieve is to have a graph comparing records by day of the week.

So basically a chart showing number or percentage of records on Monday, Tuesday, Wednesday, etc …

Must be a way to group by day of the week?

[mebeingken]

Hey Brad,

How about a custom query and use a GROUP BY WEEKDAY(timestamp_field)?

–Ken

[brad]

Took me all day but I finally got it! Using a custom query …

Might be a better way to write that query but this works …

[mebeingken]

Yep, that date_format gives the long name, while weekday gives the number. Congrats!