Tableau

Show Me recommends Tableau chart types for the fields you have selected, greys out charts whose field requirements are unmet, and rebuilds the shelves when you pick one. It is a starting point that guesses intent from field types alone.

In Tableau's own engine. Tableau's federated query layer sends a separate query to each connection, brings the results back, and performs the join locally — on Desktop, or on the Tableau Server or Cloud node running the query.

A fixed set stores a hand-picked list of members in the workbook and never changes as data arrives. A computed set stores a condition or a top-N rule and re-evaluates it each time the workbook queries, so its membership tracks the data.

WINDOW_SUM adds up the distinct counts already computed for each mark, so a customer active in several marks is counted several times. TOTAL re-aggregates the partition's underlying rows with the same aggregation, de-duplicating customers across it.

They write the clicked value into an object calculations can read: a parameter holds one value, a set holds membership. A filter action only removes rows, so it cannot drive a calculation, keep the unselected rows visible, or compare selection against the whole.

Your application authenticates the user itself, then mints a short-lived signed token that asserts that user's Tableau identity to the site — a connected-app JWT on current deployments, trusted tickets on older Tableau Server. The embedded view then loads as that Tableau user.