Sander Schenk on 04 May 2020 19:58:56
As of today, we can only select the amount of decimals a certain column or measure should have. However, it is often scientifically more useful to set the amount of significant figures it should have.
- Comments (1)
RE: Set significance / significant figures
This would be incredible even for non-scientific reports! For example, sales measure ranging between 1,000 and 10,000,000 depending on the account size. Would be nice to format as following automatically:
Rule 1: Always include at least x=3 SD's
Rule 2: Never include more than y=2 SD's after the decimal point
123 = $123
1234 = $1.23k
12345 = $12.3k
123456 = $123k
1234567 = $1.23M
12345678 = $12.3M
etc.