Grid chart - display numbers in bubbles

[raynac]

Hi all,

My company owner likes the grid chart but wants the numbers in the bubbles. 

I understand there is no native way to do this...but I found a post on Friday that had a solution, along with a matching view to show how to do it.

It's not working for me and I am not sure why.

The two dimensions were Month and Product and he added a third dimension:

=dual(aggr(count(Product),Month, Product),Product)

In my case, I am using Date and Hour and I added a third dimension:

=aggr(sum([Chats Received]),Date, Hour)

His is correct.

Whereas mine changed the colour of the bubbles to co-ordinate with the number of chats received (not entirely uncool, IMHO) but the number in the bubble is totally incongruent with that of the one that appears in the legend and popup. 

I cannot see what's amiss here.  Attaching the view in case anyone can assist! 

TIA,

Rayna

[qliksus]

whats the issue?? is the numbers wrong or you want a better display of the number ?

[raynac]

The numbers are actually incorrect.  The pop ups are fine (when you hover over the bubbles with the mouse) but the displayed numbers are wrong.

[qliksus]

The Pop-up shows the output of your expression try making your calculated dimension and expression the same and check the numbers

[raynac]

Thanks for the suggestion! I did that but there was no change. When I check the pop up, the calculated dimension and the expression match each other in all cases (and did even when the expression and calculated dimension were different).

But, still, when I click on the Labels on Datapoints, the numbers that display in the bubbles in no way coincide with the numbers I get in the pop ups. And they are consistent in being wrong. As in, the yellow bubbles should all be 2 but all say 5 etc...

[sameera]

Were you able to get this issue solved? I am having a similar problem, where the data labels do not coincide with the colors assigned to the bubbles in the grid chart. 

[raynac]

Afraid not! I wound up just disabling the display ☹

[sameera]

Actually, I got this to work. The expression used itself was wrong . I ended up using a combination of AGGR and ONLY and got the values to show up correctly. The value I wanted to display was a string and I had to group it with AGGR for it show up correctly.