I'm new to the forums and to tableau until just recently (be gentle )
I am wanting to use an area chart to examine our Quotes. I want the chart to show SEO quotes stacked on top of (Total-SEO) which I refer to as Other_Quotes
I have Quotes (metric) and Channel (SEO or total) as a dimension.
Other_Quotes = [Total_Quotes]-[SEO_Quotes]
I used these new fields to create an area chart with SEO and Other quotes on a monthly basis. I now want MoM % and YoY % in the tool tip for both SEO and Other.
Here is the calc I attempted to use:
The above calc is showing correct MoM % for Other_Quotes but for SEO_Quotes it is showing the same percentage as Other_Quotes which is obviously wrong for our SEO traffic.
I would love to post the workbook but company rules prevent it.
Any help is appreciated, thank you!
Any workbook with fake data to play with?