I am trying to use a pie chart with data from my database but i am new to this application and JS (java script) and i have tried a few things but they dont work.
This is the script i used wich didnt work:
{{table1.data['Actueel aantal in meters'][table1.selectedRow.index]}} {{table1.data['Order totaal in meters'][table1.selectedRow.index]}}
I got an error message with "the value has to be of type 'object' , you provided a value of type 'string'".
I need to get data from the database in the pie chart but the data must be from the selected line in the table.
In the Data source field you may want to enter the table row data in the second screenshot instead...assuming Miraflex.data is the result for the entire table?
but surround it with [ and ] like:
I now have this in data source, the first line works the second line doesnt.
It says: The value has to be of type 'object', you provided a value of type 'string'.
This only happens when i add the second line of the script.
Are you trying to get the values from column names?
if so it would be table2.selectedRow.data.id (or whatever the name of the column that is in the database in the original payload from the query....
More screenshots of query and table columns would help me help you
I am trying to get 2 values from table1 wich have to be from the row i selected.
In this table i need to get "actueel aantal" and "Order totaal".
I want to get these 2 values on a pie chart so the customer can see the difference between the actual produced products and the amount they wanted to produce.
I am trying to get the values from 1 row (which i can select) and 2 different collums yes, they will always be the same collums.
I have used [{{table1.selectedRow.data.Actueel aantal in meters}} {{table1.selectedRow.data.Order totaal in meters}}]
but now i get
{"message ":" JSON5: invalid character '{' at 1:55","payload":[true,true]}
