The chart shows the product ID instead of the product name

[oybek94]

Hello everyone, I made a bar chart. I have the product type linked to the sales section as a ref. In product, key is product_ID and label is Product name. When I break down weekly product sales by type, I see product_id instead of product name. How can I make the Product Name visible?

[Aurelien · Accepted solution]

Hi @oybek94 

Can you try retrieving the product name with a virtual column and use this one for your chart?

virtual column should have this expression:

[productID].[description]

 For reference:

Use virtual columns - AppSheet Help