hello all,
I am trying to compare two "Data source Name" selected from a list and show common "Column Caption". Please refer below image. It shows 1 if a column caption is present in corresponding Data Source name. For common Column captions it ll show 1 in both the columns. Is there a way to show unique% and common % figures for this? I tried using calculations and sets but it gives error like No booleans allowed in IF. Can someone suggest a better approach? Thanks
I assume you want to calculate roll ups of those lower level calcs? If so, you could achieve this using Level of Detail calculations - Overview: Level of Detail Expressions
Become a Viz Whiz on the Forums! Support the Community and master Tableau.