Change the label of a value

Bradley Dixon shared this idea 4 years ago
Completed

Hi Guys,


I know that you have mentioned that on certain charts Yellowfin can only support numerical values. For example on a scatter plot will need to have a numerical value on the x and y axis. I am wondering in these instances if we can get an enhancement to change the display label of a value. For example in the data

value, label

1=A

2=B

3=C

So when we pull the data into the scatterplot we pull in the value however on the properties on the column we have the ability to display the label


Regards,

Brad

Comments (3)

photo
1

Hi Brad,


So I could see a way to do this by;

-Using a calc field to convert your varchar to numeric.

E.g. Case when field=A, then 1, when field=B, then 2 etc..

-Use this field to draw the chart


Then if we could include a tooltip box on the Scatter chart, you could then use that original field (still Varchar) as the tooltip.

So the enhancement would be to configure the tooltip field for Scatter charts.


Does this cover what you're after?


Thanks,

David

photo
1

Hi David,


Thanks for the information however I am probably after this the other way.

Where we can use a numeric but display a alpha


Regards,

Brad

photo
1

Hi Brad,


In my below example, you are using a numeric to draw the chart, but displaying an alpha.

It will only ever work as a tooltip though.


Am I missing something?


Thanks,

David