issue with abscissas date format in a chart.

Tonio · 2011-06-22T04:47:56+00:00

Tonio

Hello, 
I run the source data in this format: 
Time (timestamp) | Value 
timestamp1 | 1 
timestamp2 | 2 
timestamp3 | 5 
timestamp4 | 5 
timestamp5 | 6 
timestamp6 | 3 
timestamp7 | 9 
 
I create a column up on the day to make a day aggregation of data. 
Column days: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>var date = new Date (dataSetRow ["Time"] * 1000)
new Date (Date.getFullYear (), Date.getMonth (), Date.getDate ())</pre>
 
In the table, my day aggregation works. 
Now in a graph with: 
Value Y: My aggregation 
Category X: My group on the day. 
I get good information but at my time I abscissas a repetition of the same date. I found a solution by converting the string but I want to date kept the format that internationalization is managed. 
Thank you in advance.

Find more posts tagged with

Comments

mwilliams

Are you using grouping on the x-axis? If not, adding a grouping might help. You can enable grouping by going to the select data tab in the chart editor and clicking the sorting and grouping button next to the x-axis field.

Tonio

Thank you ! It's working but i would like to add a curve in the same chart, calculating a average. I can't sp?cify for this serie use aggregetion COUNT and for the other one use AVG. Is it possible?
Regards,

mwilliams

There is an aggregation drop down next to the y-axis series value area of the chart editor. Try using the aggregations there to get what you want. Let me know if you have issues.