Hi Team, how can we format percentage values while downloading in csv to appear in the right format? For instance, 0.96% appears as 0.96% while downloading in Excel but when downloaded in CSV it appears as 0.96. Can we change this to appear as 0.0096 so it can easily be converted to 0.96% when users hit the % button
Hi @Tanisha_Shetty Assuming your raw data is 0.0096 which you’re formatting as a percentage within QuickSight to be shown as 0.96%, are you saying when downloading this data in excel, it shows 0.96%, but in csv it shows 0.96?
Clarifying because I cannot replicate that in QuickSight myself as when downloading in csv, I do see 0.0096
Hi @SD_QS,
Thanks for your response. I found my data to be 0.96 which is of type Number and is formatted as a %age.
I’m unable to change this format currently, is there a way that I can retain the %age formatting while downloading this as a csv?
Thanks,
Tanisha
Hi @Tanisha_Shetty It looks like while your column is a number, a suffix symbol of ‘%’ is used within the units section under ‘More formatting options’ to display it as percentage in your visualization, is that correct?
Also, I am assuming when you say you’re unable to change this format, its because formatting the column as %age would show it as 96% instead of 0.96%, is that true? If that’s the case, may I recommend that you create a new calculated field using your original column / 100 and format the new column as %age, such that when it is downloaded as a csv it will have the value of 0.0096 as you wanted?
Let us know if this helps, thanks!
You’re right - “It looks like while your column is a number, a suffix symbol of ‘%’ is used within the units section under ‘More formatting options’ to display it as percentage in your visualization, is that correct?”
Got it, thanks - I was looking for any cosmetic formatting options available to me which I could change. But looks like I’ll have to change the field itself.
Thanks,
Tanisha