Forum Discussion
prashantg364
Helper II
3 years agoCumulative total
I have 2 tables
1. Target Table, 2. Achieved Table - shown below
I linked both tables by Month columns and want to visualize cumulative totals.
X-axis I need to keep the month number from the Target table
Y axis I need to keep the cumulative total both from the Target table & Achieved table
I tried to create a visual as shown below, but from the achieved table, I need data till last month but it is showing me data till the end.
Pls suggest any way to do the same
| Target Table | ||
| Month | Target Productivity | Cumulative |
| Jan | 0.09 | 0.09 |
| Feb | 0.16 | 0.25 |
| Mar | 0.63 | 0.88 |
| Apr | 0.57 | 1.45 |
| May | 0.71 | 2.16 |
| Jun | 1.33 | 3.49 |
| Jul | 1.18 | 4.67 |
| Aug | 1.11 | 5.78 |
| Sep | 1.13 | 6.91 |
| Oct | 1.34 | 8.25 |
| Nov | 1.38 | 9.63 |
| Dec | 1.425 | 11.055 |
| Achieved Table | ||
| Month | achieved Productivity | Cumulative |
| Jan | 0 | 0 |
| Feb | 0 | 0 |
| Mar | 1.39 | 1.39 |
| April | 3.08 | 4.48 |
| May | 0.80 | 5.27 |
2 Replies
- prashantg364
Helper II
Thanks, it works
- tamerj1
Community Champion
Hi prashantg364
Try to add a conditionIF ( NOT ISEMPTY ( 'achieved table' ), your expression )