Allocating amounts such as contracts, prepayment, revenue, cost, etc. across different date ranges is a common challenge that can be solved in many ways. Let’s assume you have some rent contracts with start date, end date, and the amount that needs to be split into months based on the exact number of days in each month. Start and End dates may fall any date within the months.
Have you ever been facing the problem of showing small and large numbers together (e.g. 123,456, 789.99 and 34.56) in a nice way, lets say with a 3 digit precison as 34.5 and 123G (or 123E6), all in the same diagram.
Wouldn’t it be nice to be able to show values like this, in this case using a 3 digit precision:
Matrix with Value Dynamic Formatting
And if this also would work in all the chars like the Bar Chart below: