New Topic
CommunityTopicIdeaReport Builder
Following
photo
David Registro
APAC SD Team
Assigned
Properties
Category Report Builder
Product Version 7.3

Change the label of a value

Bradley Dixon shared this idea 7 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

1 I like this idea 0  

Replies (3)

photo
1
David Registro ● 7 years ago

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

Reply
photo
1
Bradley Dixon ● 7 years ago

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

Reply
photo
1
David Registro ● 7 years ago

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

Reply
Leave a Comment
 
Attach a file