Projections

[kevbrown]

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

[Kushal_Chawda]

what is expression for %submitted?

[kevbrown]

  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

[Kushal_Chawda]

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?

[kevbrown]

Yes they're calulations

[Kushal_Chawda]

can you share the sample data?

[Anonymous]

Please Have a look at the QVW Example Application. Might be Helpful.