hey Again a small question forgive me but it's monday and the brain is still working on sunday :-)
I want to make this sql query visual does anybody have any idea :-) SELECT date_format(t_timestamp_opened,'%Y %m %d'), count(date_format(t_timestamp_opened,'%Y %m %d')) FROM crm.ticket group by date_format(t_timestamp_opened,'%Y %m %d') order by t_timestamp_opened; +--------------------------------------------+------------------------------ ---------------------+ | date_format(t_timestamp_opened,'%Y %m %d') | count(date_format(t_timestamp_opened,'%Y %m %d')) | +--------------------------------------------+------------------------------ ---------------------+ | 2002 01 15 | 1 | | 2002 01 22 | 1 | | 2002 01 23 | 3 | | 2002 01 25 | 2 | | 2002 01 29 | 2 | | 2002 02 01 | 1 | | 2002 02 06 | 2 | | 2002 02 11 | 1 | | 2002 02 12 | 1 | | 2002 02 15 | 1 | | 2002 02 22 | 2 | +--------------------------------------------+------------------------------ ---------------------+
