I have a 360 dashboard containing two entity tables, A
and B
, with a relation defined between them. The relation connects a single field from A
to a single field from B
, and I intend to combine their data using a left filter join.
I have fields f_A
from A
and f_B
from B
, where f_A
is a numeric field exclusive to A
and f_B
is a categorical field exclusive to B
. My goal is to create a vertical bar chart visualization where f_A
defines the X-axis buckets and f_B
serves as the split series.
However, since f_A
and f_B
reside in separate entity tables, I’m struggling to configure this in Siren Investigate without relying on scripted solutions or external tools like Apex Charts.
More broadly, I’d like to understand how to build visualizations that depend on fields from multiple entity tables in a non-scripted way.