[Question] Manually adding data into database and visualise on analytics app

[elhananjair]

Hello @Rello
This is just a question to know what I am trying to achieve is possible in the analytics app, here is the situation
I want to register the network status of different branches of our company, and I want to look it at the end of the month for reporting purposes.
Here is what the data looks like

Branch Name	TT Num	Date	Time	Category	Status
Berlin	6228478	2024/10/27	8:00	Network	handling by technians
Addis Ababa	4231452	2024/09/24	9:00	Installation	Finshed

What I am looking for is to be able to insert data into the database directly from the Analytics application, and then filter by each column like by date or branch name...
So is it possible?

[Rello]

Hello,

sorry for the delay.
storing data like this in Analyitcs' internal tables is currently not possible as they are limited to 3 columns. But if the data is coming from external sources, it will work.
You could store the data in

• spreadsheet
• csv
• Nextcloud Tables

and then report on them in Analytics.
Do you think that could work for you?

[elhananjair]

Hello,

sorry for the delay. storing data like this in Analyitcs' internal tables is currently not possible as they are limited to 3 columns. But if the data is coming from external sources, it will work. You could store the data in

* spreadsheet

* csv

* Nextcloud Tables

and then report on them in Analytics. Do you think that could work for you?

Hello,
3 columns still don't work for me as I needed to get full information about all the columns I mentioned above. I was looking for a tool to do that, but I wanted to make sure first if Analytics would work for me.

[Rello]

Hi,

for this one, I would recommend to use the table app to record all data. it also has an API if I am not wrong.
Then it can be selected as a datasource in analytics afterwards and visualized in several ways.
let me know if it worked out