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?
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.