Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is my data and would like to know how to write a group by date clause in q chart.
CREATE_DATE | MSG_TYPE_ID | MSG_ID |
10/22/12 15:44 | 1000 | |
10/22/12 14:59 | 1000 | |
10/22/12 15:03 | 1000 | |
10/22/12 12:36 | 1000 | |
10/22/12 17:00 | 1000 | |
10/22/12 13:35 | 1000 | |
10/22/12 18:05 | 1000 | |
10/22/12 18:20 | 1000 | |
10/22/12 14:25 | 1000 | |
10/22/12 13:02 | 1000 | |
10/22/12 13:09 | 1000 | |
10/22/12 18:40 | 1000 | |
10/22/12 11:19 | 1000 | |
10/22/12 15:06 | 1000 | |
10/23/12 9:49 | 1000 | |
10/23/12 8:57 | 1000 | |
10/22/12 11:40 | 1000 | |
10/22/12 14:40 | 1000 | |
10/23/12 12:30 | 1000 | |
10/25/12 14:17 | 1000 | |
10/24/12 9:41 | 1000 | |
10/22/12 18:15 | 1000 | |
10/23/12 10:13 | 1000 | |
10/23/12 8:58 | 1000 | |
10/23/12 12:55 | 1000 | |
10/23/12 9:49 | 1000 | |
10/25/12 11:45 | 1000 | |
10/22/12 16:33 | 1000 | |
10/26/12 10:12 | 1000 | |
10/25/12 14:36 | 1000 | |
10/26/12 10:37 | 1000 | |
10/22/12 11:20 | 1000 |
What is your expected end result?
A chart always groups by the dimension. So you need to have a field that you want to group by and use this as dimension. Or you create a calculated dimension, e.g. =Month(CREATE_DATE). Then the aggregation (the expression) will be calculated for each value of the dimension.
HIC
take any chart except gauge ....while showing month as a group i think radar chart is best
write the dimension as
=month(date#(left(8),mm/dd/yyyy)
expression as sum(MSG_ID)
if u want to show trend take a line chart
take two dimensions
1.=year(date#(left(8),mm/dd/yyyy)
2.=month(date#(left(8),mm/dd/yyyy)
expression as sum(MSG_ID)
default chart shows group by itself....
-regards
premhas