cancel
Showing results for 
Search instead for 
Did you mean: 

Data not showing in Canvas Chart Tooltips

tomstocks43
New Contributor II

Hi all,

 

I’m having issues getting symbol data types to work in the tooltip functionality.

 

When attempting to display a view state in the tooltip that is stored as a symbol, the data type is undefined and the value isn’t shown

Also, when attempting to display data from a value in a column that is stored as a symbol, I get the same issue.

 

The data for this canvas chart is the result of a virtual query where the meta data defines the column in question as “column: 11” (symbol)

 

An example tooltip is below:

tomstocks43_0-1625223089866.png

 

 

The types have been extracted using the typeOf funciton.

Note that usually “name of x axis as symbol viewstate” and “values of other columns” would not display, in the above example I have manually defined them.

Also note that numerical values from the virtual query are displaying fine.

 

Is there a way to convert symnbols to strings in the tooltip? Or is there a different data type in the virtual query that I should be using?

Thanks,

-Tom

1 ACCEPTED SOLUTION

tomstocks43
New Contributor II

Just to close this issue, the problem was not related to data types etc, it was related to spaces in the column names (atleast in my case) 
here is an example of my column name before the fix
wont work.PNG
this caused the issue described above as when the column name was changed (both in data and in the tooltip) to the following

 will work.PNG

The data immediately showed in the tooltip as required.

 

Apologise if I missed this caveat anywhere in documentation.

Cheers,

-tom

View solution in original post

1 REPLY 1

tomstocks43
New Contributor II

Just to close this issue, the problem was not related to data types etc, it was related to spaces in the column names (atleast in my case) 
here is an example of my column name before the fix
wont work.PNG
this caused the issue described above as when the column name was changed (both in data and in the tooltip) to the following

 will work.PNG

The data immediately showed in the tooltip as required.

 

Apologise if I missed this caveat anywhere in documentation.

Cheers,

-tom