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!

Okay
  Public Ticket #3810458
Google sheet import data / graphics
Closed

Comments

  • Stephen started the conversation
    January 29, 2025 at 2:47pm

    Hello, Firstly I would like to say amazing job with your tool!

    I have reached some limitations and I hope you can advise on the best solutions:

     
    - Is there some type of aggregation feature for when graphing as similar to what is in Google sheets.  I want to graph how many times something appears in one column. it seems that you have to set 2 columns. 

    my work around has been to set a new column with a default value of 1 to use this as the integer axis. is there something I am missing?

    - Date/time, my source location format is: "September 20, 2024 at 11:28 am". I have set the formats in the main settings, however when I go to set the column as date/time from string it resets all the data within the column. is this because of the "at"?

    Is there a way around this?

    - As I added a new column, and subsequently went to update the data from source (google sheets), It flagged up that there is new columns (my work around with default value 1)

    is there a way to exclude this as a work around or would I need to have a column from source to prevent the mismatch?

    Thanks in advance,

    Stephen.

  •   Miloš replied privately