Hmm not sure what happened to the screenshots, will try again:

Hi Alex,

Can you please show me the 'definition' tab of the view builder for this field.

Looks like it's text, but you've then used a 'convert text to numeric'.
Then using an org ref code to display the number as text.
Is there a reason why you're doing this?

This means, even though the field looks like a dimension, you've told Yellowfin to convert this to a number. In which case, it cannot be used in the color box.

Hope this explains what you're seeing.

Also note, there is a current defect with using the 'convert text to numeric' converter (TASK ID = 169743) where the conversion is only 1/2 done. So even though you have applied the converter, it's not really acting as a numeric field (well, not completely).

Regards,
David

The field in the db is tiny int which corresponds to a small set of types.
We're trying to convert this to a human friendly text in Yellowfin.

Is there a better way of doing this or is the Org Ref Codes the correct method?

I don't see any place we have done "convert text to numeric" but I may have missed something.

Thanks

Hi Alex,

Thanks for the extra info.

What you're doing is correct. You have changed a numeric column to display as a dimension, then apply an org ref code.
This is fine.

However the cross-tab chart is not recognizing that it's formatted as a dimension, so this is where the issue lies.
I have managed to replicate your issue and raised a defect (TASK ID = 170147).

It only seems to be the cross-tab report charts exhibiting this problem.

We are going to have to fix this in the near future, though until then, you will not be able to use this field as the color field.
Sorry for the inconvenience.

Regards,
David

Hi David,

I was wondering if this bug has been fixed yet?

Thanks

Alex

Hi Alex,

Product Defect # 170147 was corrected and added to the September 2014 monthly YF builds.

Any further questions on this, please let me know.

Kind Regards,

Danny