Hey! Are you staying home? We are too. Still, we continue working on our product to support you with a free solution.

We hope it comes in handy for your business especially these days. Stay safe & pivot on!

Add a string to a cell (using measure)

Answered

Hi all,
Is there a way of adding a string to a cell?
For instance, lets say my data has 2 rows. Country, and Population.
And I wish to add a string, say ‘people’ to the count – so it will show for instance, 3000000 people.
Didn’t see any option of adding a string into a calculated measure…
Thanks!

3 answers

WebDataRocks Team WebDataRocks December 24, 2019

Hello,
 
Thank you for your question.
 
The desired formatting can be achieved using the currencySymbol property of the format object. More information about the format object and its properties can be found by the link: Number formatting.
 
Please check out an example we have prepared for you.
 
We hope it helps.
 
Regards,
WebDataRocks Team

filossof December 24, 2019

Thanks for your reply. Looks great.
And one more thing, is it possible to make it an HTML code? In other words, am I able to add an icon instead of the word people?
 
Thanks!

WebDataRocks Team WebDataRocks December 26, 2019

Hello,
 
Thank you for your question.
 
It is possible to add custom icons to the cells using customizeCell function. We have modified the previous example to demonstrate this functionality – feel free to check it out.
 
For more info about customizeCell please check out the following link.
 
Please let us know if you have any further questions we can help you with.
 
Best regards,
WebDataRocks Team

Please login or Register to Submit Answer