Hi, I would like to use the format_number() function in HIVE SQL in Expression field to display integer with thousand separator. I’m not able to use Display Format option because the final output is a string. Below is my expression as a text in label field of KPI visual:
concat_ws(’ ', cast(count(distinct ([AU Risk Iinstance Id])) as string), ‘Risks’) as ‘# Risk Instances’
Desired output: 1,000 Risks
Any suggestion would help. Thank you.