When using the collapsing technique you are describing, we are limited (or barred) from using both titles and captions, as they remain after the collapse. You can get a blank caption by adding ELSE ' ' to your calculation. But you're still going to get an empty caption box with a blank line, which probably isn't what you're look for. Consider using Annotations to produce your labels. They should disappear with your collapsing worksheet.
Something like this? Dynamic Annotations (Part 3) | VizPainter
I guess I want the caption to be at the bottom, sort of like an additional header but at the bottom- I'm not sure this would work in this case or would it?
Brook, we are definitely at the work-around, compromise stage, since you can't use Captions the way you want to use them. Using a hidden reference line you can make enough space below the marks (but above the axis) to make room for annotations. Like this:
But the annotations can't be outside the bounds of the marks space. Again this isn't probably what you're looking for, but maybe I'm wrong.
This is perfect! Where was this posted on the forums, so I can figure out
to make mine like that? I am struggling with annotations. This is a HUGE
On Fri, Mar 25, 2016 at 1:38 PM, Shawn Wallwork <
It seems you may have got this off of the website I posted earlier. But I actually don't see this picture of hidden reference lines anywhere on the link? I looked at part 1 and part 2 as well.
Hey Brook, glad we might have hit on a workaround for you! Yes I did adapt Josh's workbook to demonstrate how this might work for you. I'm attaching a 9.3 version of this workbook (which you may or may not be able to open). Let me know if you don't understand how it works.
Dynamic Annotations - SW.twbx 1,019.7 KB
This works great. The only problem is that as I switch companies. The
axis's are quite different. Some of the values go from 0 to 1 and others go
from 0 to 5Million, so making the axis negative -1 or in this case -40,000
won't work from company to company. Any workaround?
Thanks so much!
On Fri, Mar 25, 2016 at 3:11 PM, Shawn Wallwork <
Any new ideas or thoughts on the dynamic axis changes?
Sent from my iPhone
So you can make the 'fake reference line' dynamic by linking it to a formula. In the attached I've left the reference line and value visible so you can see what it's doing.
I've created a calculated field [fake reference line] with the following formula
This takes the Max of all SUM of Profits (as compute using is set to Table Across), Halves it and makes that negative. I drag this into the Profit marks card, and then have access to this in the Reference line set up. This way the reference line will reflect the 'scale' of the selection...you may need to adapt the half to something else, but hopefully the general idea makes sense.
Dynamic Annotations - SR.twbx 1,022.4 KB
Hi Simon this ROCKS! But since I have many measure values, I will need to
build an if statement around it. For example Company A looks at Profits
while Company B looks at Expenses while Company C looks at Fees, etc, etc.
I tried to build an if statement but I was unsuccessful. I think this is
the last step!
Thanks so much for all your help Simon and Shawn!
On Sat, Mar 26, 2016 at 10:03 AM, Simon Runc <email@example.com>