Series labels from related Table

[Annasmartweb]

Dear Caspio-community,

i am loving the tool so far. But i got one question regarding the labels of the data series in a column chart.

My values are located in a single table referring to a second (parent) table with the names of the series over the relation "Waren.id" and "Export_US.waren_id" (here are the complete names located).

When choosing a data series field for the columns i can only choose the waren_id. But i need to show the names located in "Export_US.bezeichnung".

Is there any way to do this?

 

Thank you very much for your help!

 

Best regards,

Anna

[JolliBeng]

Hi Annasmartweb,

If you want the values from "bezeichnung" to be displayed instead of "ID", you may set the Display Value as "bezeichnung"

You may refer to this article.

 

-JolliBeng

[Annasmartweb]

Thank you. But it doesnt work and i dont know what to set in the diagram.

 

[SunakoChan]

Hi @Annasmartweb,

Relationships are made by associating a field from one table to a field from another table. The fields used in relationships must be of compatible data types. otherwise, a relationship cannot be formed.

 

Visit this link for further explanation:  https://howto.caspio.com/tables-and-views/relationships/

 

Regards,

SunakoChan