Hi everyone,
I've put together a 3 input graph using the Interactive Charting tool with a combination of 1 bar chart and 2 line graphs The x axis are individual days and the y axis are values. The visualized data is accurate; however, the x axis doesn't ever show the most recent date under the most recent visualized data:
As you can see, the orange/green lines and grey bar on the farthest right are correctly showing May 29 data but the x axis doesn't actually show the date to which the most recent data should be aligned to and instead shows next day's date which doesn't have any data. I've tried adjusting the padding, adjusting the height and width, re-sorting the data, etc. and nothing has worked.
Any ideas how I can get the interactive tool to show every single date or at least correctly show the most recent data in the x axis (and not the date after it)?
Thanks!
Goran
@Goran Just before the Interactive chart add a sort tool and sort the date field in descending order and try again
@binuacs Yup, I've already done that. As I said in my OP, the data is there and the visualization itself is correct, its just that the x-axis is not showing every date in the data set, and especially the most recent date. As you can see from the screenshot, its skipping some dates on the x-axis but correctly visualizing the data in the actual graphs.
Thoughts or ideas?
@Goran would you be able to provide some sample data to test?
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |