Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm looking for some actual data and projected data on a line graph.
What I currently have for actual data is -
Revenue Period | % Submitted in 20days |
2016/05 | 54.6% |
2016/06 | 51.0% |
2016/07 | 48.9% |
2016/08 | 45.8% |
2016/09 | 49.0% |
2016/10 | 51.3% |
2016/11 | 64.1% |
2016/12 | 56.5% |
2017/01 | 59.5% |
2017/02 | 49.6% |
2017/03 | 58.1% |
2017/04 | 62.9% |
2017/05 | 61.2% |
2017/06 | 57.4% |
2017/07 | |
2017/08 | |
2017/09 | |
2017/10 | |
2017/11 | |
2017/12 |
And I want to project 2017/07 onwards My boss has produced some in excel based on 2016/05 + 2017/06 - 2016/06 for 2016/07 and so on for 2016/08, 09, 10, 11, 12.
Any suggestions would be great
what is expression for %submitted?
So % is Sum of Submitted within 20days / Sum of Total for each month
Sum of Submitted within 20days | Sum of Invoiced in 30days | Sum of Total | Revenue Period |
567 | 279 | 1038 | 2016/05 |
783 | 286 | 1536 | 2016/06 |
776 | 451 | 1588 | 2016/07 |
877 | 382 | 1916 | 2016/08 |
866 | 411 | 1769 | 2016/09 |
746 | 478 | 1454 | 2016/10 |
1053 | 774 | 1643 | 2016/11 |
841 | 657 | 1489 | 2016/12 |
1096 | 753 | 1841 | 2017/01 |
680 | 491 | 1371 | 2017/02 |
778 | 612 | 1338 | 2017/03 |
598 | 495 | 951 | 2017/04 |
916 | 621 | 1496 | 2017/05 |
912 | 792 | 1589 | 2017/06 |
all this fields available in data or this (Sum of Submitted within 20days & Sum of Total for each month) is again calculation on front end?
Yes they're calulations
can you share the sample data?
Please Have a look at the QVW Example Application. Might be Helpful.