I've seen a couple of posts and wondered if there has been any developments on this. I have a table with specific dates (these are required for us to send off to an external partner). I'd like to be able to use these dates and "group" them by month (SQL query or other wise) so that I can display charts showing when our busiest months are.
It seems that I would either need an additional field storing only the month/yr to make this happen which for the end-user is not practical.
If you have any ideas on workarounds, or can let me know if this is something you have pipelined to make happen, i would be most grateful.
You would be able to group the data if you have a column that saves only the month, so July 2020, not multiple dates for July.
So, if you have the date column set to show only month and year, and enter data like this:
The generated chart would be:
There's an option "Enable Grouping", and when that is enabled, all months are grouped:
I believe you should be able to achieve grouping for SQL tables as well, if you pass the grouping through the query. You can take a look at this thread, and it should explain how it can be done.
I hope this helps, do let us know if you need any further assistance.
I think you may have missed the start of the thread. I need the exact date storing as a spreadsheet is sent to an external body with all the data and to have 2x date fields (one for the exact and the other for the month) would in my mind be excessive.
Unfortunately this is not possible if you are displaying multiple dates for a singe month, but please feel free to leave your suggestion following this link and it will go straight to our developers for consideration.
If there is anything else we can do to assist please do let us know.
I've seen a couple of posts and wondered if there has been any developments on this. I have a table with specific dates (these are required for us to send off to an external partner). I'd like to be able to use these dates and "group" them by month (SQL query or other wise) so that I can display charts showing when our busiest months are.
It seems that I would either need an additional field storing only the month/yr to make this happen which for the end-user is not practical.
If you have any ideas on workarounds, or can let me know if this is something you have pipelined to make happen, i would be most grateful.
Regards
Dan
Hey Daniel
You would be able to group the data if you have a column that saves only the month, so July 2020, not multiple dates for July.
So, if you have the date column set to show only month and year, and enter data like this:
The generated chart would be:
There's an option "Enable Grouping", and when that is enabled, all months are grouped:
I believe you should be able to achieve grouping for SQL tables as well, if you pass the grouping through the query. You can take a look at this thread, and it should explain how it can be done.
I hope this helps, do let us know if you need any further assistance.
I think you may have missed the start of the thread. I need the exact date storing as a spreadsheet is sent to an external body with all the data and to have 2x date fields (one for the exact and the other for the month) would in my mind be excessive.
Hi Daniel
Unfortunately this is not possible if you are displaying multiple dates for a singe month, but please feel free to leave your suggestion following this link and it will go straight to our developers for consideration.
If there is anything else we can do to assist please do let us know.