Make use of >3 columns of a dataset

[derritter88]

Hi there,
I have started working with your app as it is a real handy application - perfect for visualization.
Unfortunately I am not able to add all csv columns to Analytics:
I am monitoring my bandwith with speedtest-cli which puts the output into a csv file (see attachment, neede to change .csv to .txt as otherwise Github won't accept it)
Speedtest_WAN.txt

When I open it with Analytics I just see "Date", "Time" & "Ping (ms)" - but no Down- & Upload.
Is it possible to add more values into Analytics?
Or maybe the column name is "wrong" so Analytics cannot read it?

Thanks, Mathias

[Rello]

Hello,

thank you for your request.
In fact, that will be the main part of the next Analytics version: more flexible data structures.

currently everything depends (or is being normalized to) on a object/date/value combination.
This made it easier for combining charts & tables in the first version

table is no issue, the biggest challenge will be a meaningful chart for your data.
I did not check speedtest-cli but it if could output in a transponded format, it would be much easier to visualise

now you have a keyfigure model with every number in a column. to visualize it in a chart, an account model would be perfect. e.g.

type, date, value

download, 2020-01-01 , 1.2
ping , 2020-01-01 , 1.2

this would work now already and would also provide a nice select/deselect of a category in a chart

[derritter88]

Hello @Rello ,
unfortunately your suggestions does not work for me as I have type, date, time, value.
I get those data written in an ongoing CSV file to monitor everything.

Your suggestion would work if I would create a separate CSV file for every single value.

If you have developed anything for this I would be happy to act as a tester for you.

[Rello]

Hey,
what would be your need here?
If I understood it correctly, you want to report on the file in realtime because it has all data.
or does the file only have recent data and you want to load/persist the history in Analytics?

[derritter88]

Hi,
both would work,
I get an update on the file every hour - it would be a nice feature to have all data in Analytics and then apply a filter on it - e.g.:

1. See everything (Ping, Download, Upload, Date, Time)
2. Set a filter on Download for the last 7 days

[Rello]

ok, I am looking into it as it is a valid case.
the result will be a kind of ETL where all source columns are extracted and the user needs to choose which to pick

In your case it will be 3 separate picks as you have the values in 3 columns. but as long as the setup is to be done once and then shown in one report, its easy

the only issue in your case will be the split date/time

lets see

[derritter88]

Might work if there would be a concat function?

[Rello]

For sure. Its just a matter of doing something that is generic and customizable

[Rello]

Hello,
the first version to make it more flexible is to remove the column limit on the table completely.
Until a more clever way is implemented, the chart always uses the last 3 columns of a dataset.

this does not help you (yet) completely, but is an important pre-step

[derritter88]

Great, thanks!
Looking forward to the release of 2.1.0.