Hello - I'm trying to create a summary tile on my dashboard that shows the percent change in volume from the previous year that looks something like this:
Typically, I create summary tiles by creating a worksheet that is simply a Text Box with a single value, then dragging that worksheet onto the dashboard. However, I'm having a lot of trouble creating a summary tile that just shows the "+1%" (as shown in the image above - in my case I'm trying to show the percent increase or decrease in the volume from the previous year. Is there any way I can create this?
Hi, @Noah Berko
Thank you for your confirmation.
I will also introduce methods that are not table calculation. It uses the Today function and Tableau's proprietary LOD function.
(It's a bit more difficult, but it's a useful function)
Level of Detail Expressions - Tableau
It aggregates this year's sales calculated by the Today function into a single value with LODs. Similarly, last year's figure was calculated for YOY. It is more difficult than table calculation, but please refer to it.
<this year sales>
<yoy sales>
<result>
*The attached sample file simulates Today for data up to 2022. Please be careful.
*If you get the best results from this exchange, I would appreciate it if you could choose the best answer or upvote.
