Charting on 2 connected tables

pl.kasee · 2025-02-27T00:45:26.745Z

I use firebase collections to store the data.

“Time” Collection has a field “Project” reference. “Project” Collection has more information including “Project Name”.

When I create a Pie Chart on “Time” Collection, I would like to display the Project Name from the “Project” Collection as the label. How would I achieve this?

Pie Chart Issue1592×1146 92.5 KB

pl.kasee · 2025-02-27T03:37:42.270Z

I was able to set the label expression by individual data select.

It was indeed a WU consuming activity.

Closing this thread.