Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a scatter chart with 5 expression in it and 1 dimension.
1 expression - lattitude
2 expression - longitude
3 expression - bubble size
4 expression - count of id's where sampleid= 1
5 expression - count of id's where sampleid= 2
When the value of expression 4 is 1 and value of expression 5 is 0, that bubble is displayed in the chart,
but if the value of expression 4 is 0 and value of expression 5 is 1, then that bubble is missing in the chart, but if i mouse over the position of that hidden bubble, then it shows the pop up label with value, but it does not show the actual bubble.
how to solve this issue?
If i append text to the expr 4 and 5,
like count({<sampleid={1}>} id) & 'text'
If the value of the expression 4 is 0, then it shows it as '0 text' and also the bubble will be displayed, but if i dont use the text in the expression like count({<sampleid={1}>} id) and the value is 0, then that bubble will be hidden but shows the pop up label when we mouse over the bubble position in the chart.
I am finding a similar issue where bubbles are not being displayed, yet if I toggle to a straight table, you can easily see that there are values for all 3 axes. Have you had any help with this issue?
It would be great if you share a sample app...
OK, I think I got it although I'm not sure why this is necessary: In the Presentation tab, I checked both "Suppress Zero-Values" and "Suppress Missing." This seems to have resolved the problem.