
Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
shekar shekhar Sep 30, 2017 12:07 PM (in response to shekar shekhar)stalwar1 .... your expertise needed .

Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
shekar shekhar Oct 1, 2017 3:03 AM (in response to shekar shekhar)stalwar1 ... Hi Sunny .. please let me know if this requirement is unrealistic and not possible


Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
Andrew Walker Oct 2, 2017 6:02 AM (in response to shekar shekhar)Hi Shektar,
Try this for the bar background colour:
if(
Sum(total_runs) < Above(Sum (total_runs)) AND Above(Sum (total_runs))<Above(Sum (total_runs),2)
OR
Sum(total_runs) < Above(Sum (total_runs)) AND Below(Sum (total_runs))<Sum (total_runs)
OR
Below(Sum (total_runs)) < Sum(total_runs)AND Below(Sum (total_runs),2)<Below(Sum (total_runs))
, LightRed())
giving
Regards
Andrew

Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
shekar shekhar Oct 2, 2017 7:17 AM (in response to Andrew Walker)Hi Andrew ,
Thanks for the reply , but its not the background colour i was looking for but wanted to find no. of players dismissed between those overs which has gradual decrease in runs for three consecutive overs .
Note : Actually there has been an analysis in cricket that , chances of dismissal increases when a bowler bowls continuous 34 overs with less runs . I just wanted to test that .
Thanks & Regards
shekhar

Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
Andrew Walker Oct 2, 2017 7:43 AM (in response to shekar shekhar)Try:
Over Count(player_dismissed) 6727 Not Declining 5005 Runs Declining 1722 Where Over is the calculated dimension:
=Aggr(
if(
Sum(total_runs) < Above(Sum (total_runs)) AND Above(Sum (total_runs))<Above(Sum (total_runs),2)
OR
Sum(total_runs) < Above(Sum (total_runs)) AND Below(Sum (total_runs))<Sum (total_runs)
OR
Below(Sum (total_runs)) < Sum(total_runs)AND Below(Sum (total_runs),2)<Below(Sum (total_runs))
, 'Runs Declining', 'Not Declining'),over)
Regards
Andrew


Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
shekar shekhar Jan 12, 2018 9:45 AM (in response to shekar shekhar)stalwar1 . Hi Sunny , Adding you to old problem which was solved by Andrew . But i also wanted to add ref line or any highlighting that a wicket had fallen in that over ... You know , they way it shows in commentary





Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
Peter Cammaert Oct 2, 2017 7:05 AM (in response to shekar shekhar)Next time, maybe you should include the rules of the game for cricket. Not really a major sport in either the US or Italy, I guess

Re: Need to find number of wickets fallen/dismissed in between the period of any three consecutive overs (per innings) where runs decreased gradually ?
susant Kumar swain Oct 2, 2017 8:07 AM (in response to shekar shekhar)Maybe something like the below
if( (over >=sum(total aggr(DISTINCT if ( (rangesum(Above( (sum(total_runs) < Above(sum(total_runs))) ,0,2))*1 )=2 and
(rangesum(Above( (sum(total_runs)  Above(sum(total_runs)) ) ,0,2))*1 )<15 , over ),over ))2 ) and( over<=sum(total aggr(DISTINCT if ( (rangesum(Above( (sum(total_runs) < Above(sum(total_runs))) ,0,2))*1 )=2 and
(rangesum(Above( (sum(total_runs)  Above(sum(total_runs)) ) ,0,2))*1 )<15 , over ),over )) ), sum(total_runs))