Hi I am pretty new to QuickSight. How to combine Number and String in QuickSight?
for example I want to show Average sales of the year. I am calculating average of sales it’s values is 293k. User want to show 293k Sales in the metric.
How this can be possible in Quicksight?
Hi @SatyaPaleti,
This should be feasible by using the concat function:
Let me know if you have any additional questions!
1 Like
Plus tostring to convert your number to string
Hi Brett,
Thank you so much for your reply. I have applied below formula
concat(toString(Avg(parseInt(Sales))),‘’,‘Sales’)
and I am getting below error
Hi Giri,
Thank you so much for your reply. I have applied below formula
concat(toString(Avg(parseInt(Sales))),‘’,‘Sales’)
and I am getting below error
Hi @SatyaPaleti
I tried this and it seems to work fine. I have a Pivot table
What is the visual you are using and are there other fields in the visual?
Thanks Giri,
I am using KPI
Hi @SatyaPaleti
Since the Value field requires number you can not place a field which has a string in it.
You can try this instead. Change your calculated field to only have the avg(sales) and place that in the values section of the KPI Visual
Then format as follows
Expand the Units section and select Units as thousands
Hope that gets your work done.
1 Like
Hi @SatyaPaleti,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post or was the suggestion provided above helpful?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Hi @SatyaPaleti,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.
Thank you!