sorting of grouped datetime value

jls · Post by **jls** » Wed Feb 25, 2004 9:15 pm

I have a chart where i want to sum a value and group it by months.
The chart should then be order by month jan 2001,feb 2001...jan 2002,feb2002.

Is this possible?

(is is an integer and a datetime field in the dataset)

Marjan · Post by **Marjan** » Thu Feb 26, 2004 5:04 pm

Hi.

I guess it could be done, even with TeeChart built-in summary features. To check all the potentials of summaries, check the following two examples in TeeChart demo:

"All Features -> Database Charts -> Summary grouping"
"All Features -> Database Charts -> Summary grouping -> Summary order"

In case this summary will not work correctly on your data, you can also do the sort/grouping with a query and then pass the results to TDBChart series.