nocodb / nocodb

🔥 🔥 🔥 Open Source Airtable Alternative
https://nocodb.com
GNU Affero General Public License v3.0
49.5k stars 3.38k forks source link

🔦 Feature: Dashboard/Interface/Charts #9223

Open LucBerge opened 2 months ago

LucBerge commented 2 months ago

Please confirm that the feature request does not already exist

Use case

I have a database. Now I need to create a dashboard/interface/charts from the data to make it readable. I also want to create pages where I can dispose of charts, table, KPI, text, buttons...etc the way I want.

Suggested solution

Additional context

I am not entirely sure that no issue exists for this feature request, I did not found any.

Keep in mind that a database alone does not provide any value. What makes the values is the data you can compute out of it. Without charts and dashboard NocoDB is not enough.

There is an ongoing discussion about how to draw charts in nocodb. I would like to know if you plan to do such a feature anytime soon?

xhb commented 1 month ago

I am very much looking forward to the implementation of this chart feature. It will be extremely helpful for our small business. I even believe that this feature is crucial for the success of NoCodeDB. Other features can be delayed, but the priority for this feature should be the highest.

LucBerge commented 1 month ago

@dstala As a temporary solution, how can we create charts from NocoDB data using external tools? In this discussion, users are talking about Redash or Superset. Can we connect it to NocoDB cloud?

D1reW0lf commented 1 month ago

This would be really handy indeed.

dalekirkwood commented 2 weeks ago

I think even an easy to use connector to Metabase would be great. Building everything in is never a good idea. Integrations rule!

LucBerge commented 1 week ago

@dalekirkwood Maybe we can also create issues on dashboard tools like Metabase and request for a NocoDB connector.

Maintained


Matomo, Umami and Turnilo are for web analytics only.

paoliniluis commented 1 week ago

You should be able to connect to NoCoDB via duckdb through their API extension, or even postgres as well. We won't be able to connect to this DB till we develop a REST API DB connector https://github.com/metabase/metabase/issues/4831

LucBerge commented 5 days ago

@paoliniluis I can succesfully connect to NocoDB using the API connector in AppSmith. The problem is that NocoDB has a pagination system to retrieve records that does not allow a user to get all the records, the maximum being 100. The only way to get all the records is to have a proper connector

dalekirkwood commented 5 days ago

@paoliniluis I can succesfully connect to NocoDB using the API connector in AppSmith. The problem is that NocoDB has a pagination system to retrieve records that does not allow a user to get all the records, the maximum being 100. The only way to get all the records is to have a proper connector

@LucBerge - I think we did it with pagination. Let me see if I can make an example and send it over.

dalekirkwood commented 5 days ago

@LucBerge - ok, so it's quite easy to add pagination. Here is the community Template - https://community.appsmith.com/template/nocodb-pagnation

Basically, the key is to use the 'offset' parameter image

and in the UI, select 'Server Side' Pagination and call the query on click image

This method will miss the first page, I am sure there is a nice easy way to fix that, but my brain is tired 😴

dalekirkwood commented 5 days ago

@dalekirkwood Maybe we can also create issues on dashboard tools like Metabase and request for a NocoDB connector.

Maintained

Archive

@LucBerge - sorry I missed this. Yes we can. It's a great idea. It seems to me to be a real shame that there is not better integration between open-source tools.

LucBerge commented 4 days ago

. Let me see if I can make an example an

[APPSMITH] @dalekirkwood Regarding my pagination use case, I was trying to get all the records to compute something out of it, draw charts and displays sums in a text box. What you showed is for Tables only. Here is the solution : https://github.com/appsmithorg/appsmith/issues/16877#issuecomment-2450334822