Hi all,
I have read multiple posts but still can’t find a solution for mine. And I think I missed something really basic here.
The dataset is for example
| Task | Planned complete date | Actual complete date |
|---|---|---|
| A | 1/1/2024 | 1/5/2024 |
| B | 1/3/2024 | 1/23/2024 |
| C | 2/2/2024 | 3/1/2024 |
| D | 3/5/2024 | |
| E | 4/12/2024 | |
| F | 4/28/2024 |
I need to make a line graph that showed the one line for MoM sum of planning and another line MoM sum of actual completion so it can provide an overview of the gap of planning vs actual completion.
Something like that -
I have these 2 calculated fields and each of can make their own line graph but I can’t have them show together like above. I am 90% sure this is caused by my x-axis but I dont know how to fix this.
(I know above is WoW view, that is just an example from other’s, mine one will be MoM)
Could anyone please point a direction? Thank you!
Y-axis: runningSum(count(task), [truncDate(“MM”,{planning}) ASC],[truncDate(“YYYY”,{planning})])
X-axis: planning group by month
Y-axis: runningSum(count(task), [truncDate(“MM”,{completed}) ASC],[truncDate(“YYYY”,{completed})])
X-axis: completed group by month