Forum Discussion
Dynamic Histogram showing total earnings for each simulation
Hi all,
I`m trying to create a dynamic/filterable histogram that shows:
x-axis: sum of earnings per simulation number
y-axis: Number of simulations in each bucket (Distinct Count of Simulation Number)
Filters: a. Asset Scenario & b. FY
Using the following data:
| FY | Asset Scenarios | Earnings values | Simulation Number |
| 22 | 23 | 0.830882 | 1 |
| 22 | 23 | 0.780357 | 2 |
| 22 | 23 | 0.692215 | 3 |
| 22 | 23 | 0.398168 | 4 |
| 22 | 23 | 0.99823 | 5 |
| 23 | 22 | 0.930938 | 1 |
| 23 | 22 | 0.32492 | 2 |
| 23 | 22 | 0.61862 | 3 |
| 23 | 22 | 0.790725 | 4 |
| 23 | 22 | 0.223686 | 5 |
| 23 | 23 | 0.240326 | 1 |
| 23 | 23 | 0.255442 | 2 |
| 23 | 23 | 0.902836 | 3 |
| 23 | 23 | 0.053757 | 4 |
| 23 | 23 | 0.798733 | 5 |
| 22 | 22 | 0.820999 | 1 |
| 22 | 22 | 0.973459 | 2 |
| 22 | 22 | 0.964044 | 3 |
| 22 | 22 | 0.225193 | 4 |
| 22 | 22 | 0.3573 | 5 |
1 Reply
- lbendlin
Super User
This is not a histogram but it is dynamic. For a histogram you'll have to change the sort order as needed
see attached.
