forums

I'm interested in constructing *conditional* hyperlinks between Sheets inside a workbook.

By this I mean that the hyperlink might look consistent from one sheet to the next, but dispatch in a conditional fashion.

More concretely:
Suppose I always do Analysis A for each of a variety of subsets of my data. Perhaps this is done by a bunch of duplicates of Analysis A ... call them A1, A2, etc ... that are in my workbook, with different filters applied ... or perhaps the A's in fact differ from one another in some other aspect.

Suppose also that I commonly do Analyses B1, B2, etc and Analyses C1, C2, etc that correspond with A1,...,An respectively. The desire is when right-clicking in Ai, to have a hyperlink named 'B' that takes you to the sheet for Bi, and a hyperlink named 'C' that takes you to Ci, for each i=1,...,n. By being consistent in naming the sheets, one could imagine a workable conditional dispatch of this kind.

I've tried to do this, but I see two issues:

1. I don't know of a parameter that determines what sheet I am in.

2. The hyperlink for sheets doesn't offer the same configurability as the URL hyperlinks do.

A workaround for #2 would be to use a conditional URL to invoke a bookmark, if #1 was solved.

Is what I am after possible in the current version of Tableau?

Thanks,
Greg