Percent difference from DYNAMIC value

tableaucommunity@tableau.com — Fri, 07 Feb 2014 22:51:29 GMT

Hi All,

I'm trying to alter the current quick calculation function within Tableau to enable a user to choose a dynamic value generated from a parameter rather than the usual FIRST, LAST, PREVIOUS or NEXT options in the (% Difference From) calculation.As you can see below, I have chosen the FIRST option to index the three variables against the first QTR date value in the data.

I would like a user to choose a value (QX YY) from a parameter to act as the index point e.g. Display the value as a percent difference from (QX YY).

I presume this can be done by customising the calculation code but this is where I hit my limits.

I have started here: http://public.tableausoftware.com/views/DynamicIndex/Dashboard1?:embed=y&:display_count=no

Please help!

Dynamic index value in line chart

tableaucommunity@tableau.com — Tue, 21 May 2013 15:03:10 GMT

Hi all,

Apologies if this is a simple question but I cannot find a solution.

Say I have quarterly data from Q1 2010 to Q1 2013 and have a value each quarter. Now I want to show a simple line chart over time of this value as an index. However, I want to have a dropdown on the final dashboard which enables me to change the quarter to which the variable its indexed against.

How can I do this?

Thanks

Lewis

Content in Tableau Community Forums

Percent difference from DYNAMIC value

Dynamic index value in line chart