Hi somesoni2,
Thank you for the suggestions. I tried all there and here are the results. Unfortunately, the x-axis is still not showing the year or date correctly.
== Set 1==
- on Statistics tab
results are returned in the following format:
Category, Order Year, Profit
Furniture, Y2011, 5450
on Visualization tab
When visualized results using Scatter Chart, the X axis values are showing as
0 10 20 30 40 50 ... 90
instead of
Y2011 Y2012... etc
And all the values are bunched together on x=0. Not sure why that is happening.
== Set 2==
I added following line to the search to format data for the scatter plot
| table Category, _time, Profit
on Statistics tab
the results are returned in the following format:
Category,_time, Profit
Furniture, 2011, 5450
on Visualization tab
When visualized results using Scatter Chart, the X axis values are showing as
2,010 2,011 2,012 2,013
Looks like the scatterplot is still interpreting the x axis values as numeric.
== Set 3==
I added following line to the search to format data for the scatter plot
| table Category _time Profit
on Statistics tab
results are returned in the following format:
Category, Order Year, Profit
Furniture, 2011-01-05, 5450
on Visualization tab
When visualized results using Scatter Chart, the X axis values are showing as
0 10 20 30 40 50 ... 90
instead of
2011-01-05
2011-01-10
etc..
And all the values are bunched together on x=0.
Thank you
... View more