This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Having different number formats on one dimention

Posted on 07-29-2024 09:59 AM
Ana-guadron
New Member
Reply posted on --/--/---- --:-- AM

Hi, so I am working on a dashboard in Lookerstudio, and I have been having trouble at changing the format of specific values within one dimension. 

For example, in my chart, I have the dimension Actual and Montly Target,  the values are sometimes percentages, sometimes currencies and sometimes decimals dependic on the metric ... is there a function that I could use to combine differnt number formats in one calculated field? 

So far I temporary solved the issue by using.. 

CASE WHEN and CONCAT(value, '%')  but this is not ideal as I was using my numbers as ,TEXT datatypes.. so controling my decimals was an issue, . 

Thank you! 

0 1 103
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
sam8
Staff
Reply posted on --/--/---- --:-- AM

No, each field can only have one format. 

Maybe create one field per format? And then swap out the fields as needed?

0 Likes