Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Continous mean calculation

hello everyone

I have a table that holds this information

DatePlayerGoal(s)
01/01/2018Ronaldo1
09/01/2018Messi1
19/01/2018Ronaldo 0
09/02/2018Ronaldo

3

10/03/2018Ronaldo0

I need to calculate Ronaldo scoring rate as the time increase

As at 01/01/2018 to 01/01/2018

Ronaldo scoring ratio is 100% since one goal in one match

between the period 01/01/2016 to 10/03/2018  His ratio is 75% (3/4)

How can I make it a dynamic system?

Regards

0 Replies