Text as popup causing extra data points to appear

[shinnickr]

Hi there,

I am using the trick described here: Pop up Text with more information to have some additional pop-up information when people mouse over the bar chart.  For some reason though, when I enable this extra expression it causes extra data points to show up even though there is no data for it.

Here you can see the graph with the extra data points.  They don't have any data like "DVHPYSN" does, but are still shown.

Does anyone have any ideas as to why this is happening?

Thanks for any help!

[sunny_talwar]

Use an if statement to display the pop-up information only when a data point exists. Assuming your first expression is the data point, you can try this

If(Len(Trim(Column(1)) > 0, Popup Text Expression)

[shinnickr]

Hi Sunny,

Thanks for your help.

I did that but I'm getting an error in my expression. 

I tried messing around with it a little but couldn't figure out where it's getting the error.

[sunny_talwar]

Is this the expression for your text popup? Also, you have an extra parenthesis at the end also

[shinnickr]

My expression for the popup has some set analysis in it, so I am just using this to make it easier when asking for advice.

And I'm not sure on the parenthesis. When I remove the last one, the edit expression box turns the parenthesis next to If red, indicating it's missing one.

[sunny_talwar]

You need another parenthesis after Column(1))) to close for Len() function

[shinnickr]

I just copied and pasted what you wrote out!  So I'm still blaming you. =0)

So it's sort of working now.

If I have just an expression in there, the popup text works and there are no extra data points.  But if I add text to it, the data points come back.

So

    This works - If(Len(Trim(Column(1)) > 0, Sum([Trach_Flg_Cnt]))

    But if I add some text to it like If(Len(Trim(Column(1)) > 0, 'Trach Flag Count = ' & Sum([Trach_Flg_Cnt])) ,then it adds those random data points again.

[sunny_talwar]

That was my bad ... try this

If(Len(Trim(Column(1))) > 0, 'Trach Flag Count = ' & Sum([Trach_Flg_Cnt]))

[shinnickr]

Oops, see I missed the parenthesis there too.  Now we're even.... =P

That is what I have.  With the 'Trach Flag Count = ' the extra data points come back, but without it, they don't.

It's pretty weird....

[sunny_talwar]

That is weird, have you made sure that 'Suppress Zero Values' is checked on the presentation tab of the chart properties?