Decimal numbers in Calculated Metrics

osvaldom

02-05-2019

Hi! I just noticed calculated metrics are showing decimal numbers (float) in CSV files or when it is copied into clipboard:
1744810_pastedImage_1.png
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:

1744809_pastedImage_0.png

Someone know Why is this happening? There is something that changes after new feature implementation?

thank you in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Asheesh_P

MVP

16-05-2019

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

Answers (3)

Answers (3)

karandeeps51149

Employee

02-05-2019

Hi,

There is no recent changes that could have caused such issue. I will suggest you to please raise incident with customer care so that they can help you.

Also, provide Login company, report name and calculated metric name. I will try to check and update.

Regards

Karandeep Singh

osvaldom

03-05-2019

Yep! I understand that, the issue is we selected in the calculated metric options zero decimals, and it was working until past days (we just noticed), that's why I am asking.
1745442_pastedImage_0.png

It was working fine.

Asheesh_P

MVP

02-05-2019

It doesn't look an error to me.

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.  

Hope that helps.

Thanks,

Asheesh