Best Of
Re: SQL formula for blank cells
You could do something like this:
CASE WHEN TRIM(fieldname) = '' THEN 0
ELSE IFNULL(fieldname,0) END
This will check to see if it is blank or if it is null (which are two different things) and replace it with 0 if either are true. Otherwise, it will return the existing value.
Re: EBay Connector
You can also create your own custom connector to pull eBay data if you are technical enough and know javascript
Re: EBay Connector
Hi @kav_100, this has been requested a fair few times in the forums over the years but nothing is available still in the connector catalogue. Definitely recommend raising an idea (including outlining which set of metrics you'd like to see: ) for others to upvote and get further tracking towards a standard connector set up
amehdad
Re: Nextiva Integration
Thanks for that input Mark! I'll look into that. BTW congrats on being #1 on the innovator leaderboard 😅
mmisky87
Displaying what controls bubble size on a bubble chart
I love bubble charts. People may need them explained once or twice, but then bubbles are just so great at packing interesting information into a big space.
I've had a look, and I think I'm missing something obvious: How do you label what's controlling the bubble size? It's critical to know this when you're trying to interpret a bubble graph, but I don't see where it shows up. It can appear in a hover as a value, and you can indicate something in a (long) title.
The same question applies to labelling the series use to color the bubbles, etc., if used. In my current example, I'm only using x,y and size.
Thank you!
P.S. I did look through the docs and hunt through the options in the Analyzer...but I could have missed what I'm looking forward. A friend describes that phenomenon as "fridge blindness." As in, "Where are the pickles?"...and they're right in front of you.
Re: Displaying what controls bubble size on a bubble chart
I've added an enhancement request, in case anyone else is interested in the same feature.
Bubble chart legend enhancement: Show source and example of bubble scale and color
The idea is to use a legend to explain the bubble size and color, if used.


