Tableau how to show prior period when filter is applied

2018-08-24T16:14:41+00:00 August 24th, 2018|Tableau|

This type of question, 'How do I show prior month when using a month filter?', 'My Year on Year is blank when I filter?',  appears A LOT on the Tableau forums. There are two main ways to show the prior period / keep a previous value for prior period comparison. 1. Parameter Create a parameter [...]

Excel Product function in Tableau

2018-08-14T19:28:24+00:00 August 14th, 2018|Excel, Tableau|

I stumbled across a question on the Tableau forums asking how to write the Excel Product function in Tableau. Full credit for the answer goes to Brian Bell in the comments of this thread https://community.tableau.com/ideas/1857. The Product formula in Tableau is: EXP (SUM( LN ([FieldName]) ) ) Should [FieldName] be a series of financial returns [...]