When I purchased charts extension, what I was hoping to be able to do is ....

- I have a table that records website logins. Just two fields. One for User ID and one for the timestamp of when logged in.
- I would like to do a chart showing the total number of logins each day (last 7 days), or each month (last 12 months), or each year etc ....

I can't see a way to do this. Is this possible?

Hi Brad,
So is what you are trying to do - to group by date, and then show the count for each date?

Exactly.

Hi Brad,
I am afraid this is not possible at the current version. Will check how can such options be integrated in the next updates.
I would suggest creating an sql view, which returns your results like that, so you can bind them directly in the chart.

That’s unfortunate, I would think things like sales charts and such from live data would be a very common use.

I’ll see what I can do with a view and see if I can do it.