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.