Forum Discussion

CJay11's avatar
CJay11
New Member
2 years ago
Solved

Creating a dataframe/visual table based purely on hardcoded strings and calculated measures

Hi,  I would like to create a table which is formatted as follows: "Metric"     / "Last Match"                        / "Last 5 Matches"                    / "Last 10 Matches" "Goals"      / [La...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  CJay11 ,

     

    Here are the steps you can follow：

    1. Create calculated table.

    MetricTable =
UNION(
    ROW("Metric","Goals","Last Match", [LastMatchGoalCount],"Last 5 Matches",[Last5MatchGoalCount],"Last 10 Matches",[Last10MatchGoalCount]),
    ROW("Metric","Corners","Last Match",  [LastMatchCornerCount],"Last 5 Matches",[Last5MatchCornerCount],"Last 10 Matches",[Last10MatchCornerCount]))

    2. Result:

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  CJay11 ,

 

Here are the steps you can follow：

1. Create calculated table.

MetricTable =
UNION(
    ROW("Metric","Goals","Last Match", [LastMatchGoalCount],"Last 5 Matches",[Last5MatchGoalCount],"Last 10 Matches",[Last10MatchGoalCount]),
    ROW("Metric","Corners","Last Match",  [LastMatchCornerCount],"Last 5 Matches",[Last5MatchCornerCount],"Last 10 Matches",[Last10MatchCornerCount]))

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly