toss decision

[shikhar6339]

Hi All,

I have the below data which I want to represent in a pie chart showing percent of team batting first won vs team bowling first won.

Please let me know if anything else is required.

Team 1	Team 2	Toss winner	Toss decision	Winner
abc	xyz	abc	bat	xyz
xyz	rst	xyz	bowl	xyz
rst	xyz	xyz	bowl	xyz
abc	xyz	xyz	bat	abc
xyz	abc	abc	bowl	abc
abc	rst	rst	bat	rst
rst	xyz	rst	bowl	xyz
xyz	abc	abc	bat	xyz
abc	xyz	abc	bowl	abc
xyz	rst	xyz	bowl	rst
rst	abc	abc	bat	rst
abc	rst	abc	bowl	rst
rst	abc	rst	bowl	abc
abc	rst	rst	bat	rst
xyz	abc	xyz	bowl	xyz
rst	xyz	xyz	bat	xyz
abc	rst	rst	bat	rst

[Samarth_18 · Accepted solution]

Hi @shikhar6339 ,

You cna create a column with below code:-

Bat_or_bowl_first = if(Table_[Toss winner] = Table_[Winner] && Table_[Toss decision] = "bat",1,0)

Now create these two measure:-

_bat_first = COUNTROWS(FILTER(Table_,Table_[Bat_or_bowl_first] = 1))

_bowl_first = COUNTROWS(FILTER(Table_,Table_[Bat_or_bowl_first] = 0))

Output:-

Thanks,

Samarth