When the users download the underlying data, They'll get the full number and not the k or m or b. As per the ####s you can either adjust the canvas size or utilize a calculation where you can divide the number by a multiple of 10 that is within the range of numbers you are looking for. For example if your numbers are always in 100,000 range, you can either go with the suffix 100k or create a calculated field that replicated 100,000/1000, where you would get "100". The problem with this option is that your users won't be able to make the right calculation since the number is off by multiplier of 1000.
Hopefully that helps.
Thank you for your reply. It should be readable and printable on PDF with 4 quarters of data with initial balance/budget/actual/scores etc so adjusting the canvas size or the width of the column. If I format it with K/B it shows as K or B downloaded(crosstabbed).
I thought of dividing by 1,000 like you suggested, however it contains LOD calcs, IF statements, coalesces, filtered by attributes...so it got really complicated I don't think this is any easy since we are not supposed to manipulate the data just with a note "all numbers are written in the thousands" like they do in financial statements...
2 of 2 people found this helpful
custom format: #, or #,#, (depending if you want a comma separator)
This can be extended to millions as well: #,#,,
btw - this is same formatting that Excel uses.
Thank you! I was able to solve it by using #,#,
Have a great day!!
I just started using Tableau and I saw your comment on this thread. I'm actually having trouble downloading the full underlying data from my dashboard.
For example, I have a value 1,234,567 which I've changed to 1.2M in my worksheet. When I download it to Excel as a csv file, it still shows 1.2M, when I want to be able to see the full number.
Thanks in advance for your help!