Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to know your advice of solving my problem. I have a table which has a structure as showed below:
Header 1 | Header 2 | Header 3 |
---|---|---|
MatchID | HomeTeamName | VisitorTeamName |
And I have separate table which has all team names. So I need to filter my table by Team name which can be in the field HomeTeamName OR VisitorTeamName
Do you have any ideas how to solve it?
Thanks,
Add a column =Count({<HomeTeamName=P(TeamName)>}HomeTeamName) + Count({<VisitorTeamName=P(TeamName)>}VisitorTeamName)
Suppress zeros on the column and you can hide the column.
Add a column =Count({<HomeTeamName=P(TeamName)>}HomeTeamName) + Count({<VisitorTeamName=P(TeamName)>}VisitorTeamName)
Suppress zeros on the column and you can hide the column.
if it just to show such matches in a chart table - can be achieved through expressions like below.
Dimension - MatchID
Expression1 = "MaxString({$<MatchID={"=if(HomeTeamName=TeamName OR VisitorTeamName=TeamName,1,0)=1"}>}HomeTeamName)
Expression2 = "MaxString({$<MatchID={"=if(HomeTeamName=TeamName OR VisitorTeamName=TeamName,1,0)=1"}>}VisitorTeamName)
Thank you, but my question was solved in a previous answer
Thank you. I don't understand how it works, but it works and I'll try to understand proposed solution later!