Forum Discussion
Advocate IICan't amend the date format
I feel that this is a really simple issue that I just can't seem to resolve. The raw data is in date format but I want to show the information by month. As you can see in the photo, its splitting it up in chronological order without consolidating them into months. Any ideas as to how I respolve this would be much appreciated :)
Hi mbrierley,
If you click on the dropdown for your date value on the axis, you should see a menu with an option to create a "New Group".
Select this and you'll see an option to create "bin size" - you should be able to choose a bin size of "1 month".
Click OK and there should be a new value in your date table called "Date (bins)" (or something similar, depending on what your date is called).
You should use this field and replace the date field in your graph.
Hope that helps,
Alex
2 Replies
alexei7Continued Contributor
Hi mbrierley,
If you click on the dropdown for your date value on the axis, you should see a menu with an option to create a "New Group".
Select this and you'll see an option to create "bin size" - you should be able to choose a bin size of "1 month".
Click OK and there should be a new value in your date table called "Date (bins)" (or something similar, depending on what your date is called).
You should use this field and replace the date field in your graph.
Hope that helps,
Alex
mbrierleyThat's the one! Thanks :)