Holiday Notice – Support Unavailable on April 18 and April 21

We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!

In the meantime, if you need any help, feel free to:

Amelia YouTube Channel

wpDataTables YouTube Channel

Thank you for your understanding, and we wish you a wonderful holiday weekend!

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

Comments

  • Stephen started the conversation

    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