Hi! I just noticed calculated metrics are showing decimal numbers (float) in CSV files or when it is copied into clipboard: To be specific, we were using a calculated metric for the user count and one month ago, it was displayed as a whole number, but in the last report it shows with decimals.
I already check if the calculated metric is selecting decimal numbers (example below), but it does not:
Someone know Why is this happening? There is something that changes after new feature implementation?
I came across with recent changes in the workspace CSV download and copy to clipboard. i.e.
Starting on April 11, 2019, several changes were made to CSV downloads (and Copy to Clipboard) from Analysis Workspace to remove formatting from exported data. This change was made to make it easier for customers to apply customized formatting to the exported data.
See more details in Analytics > Update to CSV downloads from Analysis Workspace > Updated April 10, 2019 section in the following the link: Experience Cloud Help
Calculated metrics setting allows you to change the formatting (i.e. decimal, percent, etc.) to present in the desired format on the workspace dashboard.
A Comma Separated Values (CSV) file is a plain text (unformatted) file that contains a list of data, therefore, .csv export is supposed to remove any formatting which was changed to display on workspace dashboard. Similarly, when using "copy to clipboard" it copies value as text (unformatted) else you will have HTML copied with it.
To test it, download the same report in PDF format. it should not remove calculated metrics formatting while download. As PDF file preserves the original graphic appearance on workspace dashboard.