topic Re: Count games in Management & Governance

Count games

Mathias — Thu, 09 Aug 2018 10:06:33 GMT

Hello everyone,

so...

Fact Table:

Dim Home_team

Dim Away_team

And a variable value team_select="Team 2"

I want a KPI that represents how many times that Team 2 played "home" and a KPI that represents how many times that Team 2 played "away". What is the Expression that I have to use?

Thanks!

Re: Count games

sunny_talwar — Thu, 09 Aug 2018 16:49:21 GMT

May be this

Times Team 2 played "home"

Count({<home_team_id = {2}>}ID)

Times Team 2 played "away"

Count({<away_team_id = {2}>}ID)

Re: Count games

Mathias — Thu, 09 Aug 2018 16:52:06 GMT

I have to do it with the variable because It is possible to change the variable in the app