1 of 1 people found this helpful
One option for the labeling would be to create a calculated field similar to the following:
if [%lift]>0 then str[%lift] else 'hide' end
Then, right click on hide and select Hide. (You may need to format the %lift a bit.)
In terms of the AD, another calculated field similar to the following could be created and placed on the label shelf
if datepart('week', [Date])=datepart('week', today()) then [AD] end:
Hope this helps!
An alternative I use is to do IF [%lift] > 0 THEN [%lift] END and put that on the Label Shelf. Then I can use Tableau's built-in number formatting, and Tableau won't draw the Null labels.
As for adding arbitrary text to a chart, there are lots of options there, I did a post awhile back on a variety of techniques for showing totals but they'd apply to other options as well: http://drawingwithnumbers.artisart.org/annotating-a-view-with-a-total/
Ok...both answers were very helpful...but even though I was able to add the lift % ONLY to datapoints >0%; I still dont know how to add the AD DESCRIPTION (which is a dimension on my workbook) to those data points where lift % > 0%.
Also my charts have 2 lines - one for TOTAL DOLLARS and one for BASELINE DOLLARS on same axis. Is there a way I can add the Lift% only to the TOTAL DOLLARS line? Right now it's showing on both....
Thanks a lot!
Tracy and I were able to answer your initial question based on your description, but now the questions have gone deep enough that we need to know more details about your view, ideally with a packaged workbook with some sample data. See So Your Question Didn't Get Answered... for reasons why.
Thanks again for helping out! I spent quite sometime doing some searching on the Forum today and ended up figuring out. I used double axis and therefore was able to label only one chart.
I am very excited to be able to move some of these analysis to Tableau and stop with the crazy XXX GB excel!!!
I'm glad you figured it out, and I hope you continue to be excited to use Tableau!