Forum Discussion
scatter plot with date on the x-axis
Hi,
I tried using a dummy data..
Keep the Date hierarcy selected..
Under X-Axis, Concatenate-Off (toggle)
Hope it works
Hi,
Go to formatinng of the line chart
Under options, find X-Axis
Then Select the Type as Categorical
Scroll below to find Show marker and move the toggle to 'on' position
Increase the size of the bubble..you can choose the shape of the marker as well as the size and colour
Scroll up to see Data colours and choose the data colour as white..(Pls keep the background same as white, else select the data colour same as the background)
Thats it..
Hope it helps
Hi
Many thanks for the help! It works.
However initially the x-axis is set as per month (since there are many price points per month and I averaged for each month, so for each month there is only one price point). After adjusting the x axis to categorical, every single price point shows up...so the x axis is extremely long now....
Hi,
I am not sure if you have prepared a different sequential date table and connected your date from data with that. This helps because you can then use this date from sequential date table in all your plots.
Based on the level of drill down, the date table will have categories displayed on X axis
It would start with a year then move to Quarter-Month-Week and Day
Automatically, your data, which may be daily will get summed or averaged (based on the measure you choose during plotting)
On the other hand, if you have already connected, then just drilling up should solve your issue
Hi,
My data contains several years of price information therefore when I drill down to month, it only displays from Jan to Dec. Would I desired is from e.g. 2014 Jan to 2018 Dec, every month there is an average price point of all the products sold during that month.
