We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
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.