Category: How do I do X?
Updated

This solution is summarized from an archived support forum post. This information may have changed. If you notice an error, please let us know in Discord.

Visualising experimental data as a family tree type graph

Issue

I am using Appsmith for the first time and I have some questions and issues. When importing data from Google Sheets, some values are imported as blank. How can I fix this? Also, the "displayValue" option doesn't work on Sankey charts. Is there a way to overlay text on a chart or a similar workaround? For now, I am considering adding a hyperlink to the chart that links to a Javascript function that changes the selected row in the table and updates the relevant scripts and widgets.

Resolution

The solution discussed in this conversation involved building an Appsmith app with three main functionalities: displaying the latest data values, showing the genealogy of ancestors and descendants of a selected row, and displaying a line chart for all readings on different dates for the selected ID. The app operates on two CSV files (which will eventually be migrated to an actual database), with one file containing data on ID, date, and value, and the other file containing data on ID, parent, XX, YY, and ZZ.

For displaying the latest data values, the app uses a table widget to fetch the data from the first CSV file and display it. For showing the genealogy of ancestors and descendants, the app uses custom JavaScript code to extract and format the data from the second CSV file and display it in a sankey custom diagram upon a row selection event in the table widget. Finally, for displaying a line chart for all readings on different dates for the selected ID, the app uses a chart widget to display the relevant data fetched from the first CSV file.

The conversation also addressed two issues: (1) importing data from Google Sheets in which strings are returned as blank values and (2) overlaying text on sankeys, which is not supported in Appsmith. The workaround for the first issue is to use a dummy row that specifies data in the expected data type or ensure that the first row does not contain only digits for the relevant column. A solution has been requested for this issue on the Appsmith GitHub page. For the second issue, no immediate solution was identified, and the suggestion was to try adding a hyperlink to the chart widget and linking it to a JavaScript function that updates the selected row in the table widget, which then triggers an update to all relevant scripts and widgets.