Detach a chart but not show the word 'Detached'

[#1]

Can I detach a chart without showing the word 'detached'?

[Anonymous]

I do not know if it's possible. But as an option, you can remove the title bar and put the title in the chart.

[Anonymous]

[sunny_talwar]

I guess what is the reason behind detaching this chart? You don't want the values to change based on selections? Use Set analysis {1} for that may be

[#5]

yes. Is detach the only way to make it static ? Buy the way, how to use Set analysis {1}, can you give an example? sounds interesting.

[krishnacbe]

Hi,

Please Share your expression used in detached chart, we can help to convert into set analysis expression.

[sunny_talwar]

So lets say you have two expression in your chart

Sum(Sales)

Sum(Cost)

You can make your chart static by adding {1} like this

Sum({1} Sales)

Sum({1} Cost)

Now, any selection in the dashboard won't impact for this particular chart

[#8]

I need the chart title to stay, but I don't want to see (detached) when I detached a chart.

[sunny_talwar]

Also check out these links for good understanding of set analysis:

A Primer on Set Analysis

Implicit Set Operators

Set Analysis: syntaxes, examples

[ZoeM]

I had the same issue. One work around i found was:

=[CY]&' '&'Look Ahead'&' '&CHR(10)

Add CHR(10) at the end of your expression. Works fantastic for me