My favorite blog on MicroStrategy is Bryan's MicroStrategy Blog. That's where I found a very helpful post on custom formatting which I have used a couple times.
The issue is the following: You have a metric that can contain very small and very large values. How can you make sure that the value is always useful for the user (10 Mio instead of 10,000,000 where you have to count the 0 to know what it is) and that it doesn't take too much space on the dashboard?
Just use the custom formatting for values. It allows entries like the following:
[>=1]0%;0.0%
which translates to values >= 1 are displayed as full values otherwise at least one decimal will be displayed.
You can read all details here: Custom Formatting Strings
The issue is the following: You have a metric that can contain very small and very large values. How can you make sure that the value is always useful for the user (10 Mio instead of 10,000,000 where you have to count the 0 to know what it is) and that it doesn't take too much space on the dashboard?
Just use the custom formatting for values. It allows entries like the following:
[>=1]0%;0.0%
which translates to values >= 1 are displayed as full values otherwise at least one decimal will be displayed.
You can read all details here: Custom Formatting Strings
Comments