Forum Discussion
Helper IIICreate Table
Hello,
Thank you very much for the help provided.
I solved my problem using the HTML visual.
Helper IIIMy file is too big and complicated to share.
I put a "Matrix" visual but why don't I have the columns that I indicated in the configuration.
Here's an example I made quickly. https://drive.google.com/file/d/1rIQ_DQlX4stm936jYJABbAXi27cpGkvm/view?usp=share_link
Community ChampionMathieuF So given the sample data provided, what are you desiring to see in the visual? I'm not quite understanding what you want to see in terms of the actual numbers.
- MathieuF
I would like to have 3 columns, Agent, Team, Skill
- Greg_Deckler
MathieuF I understand that. But, what are the actual numbers that you want to appear in those columns? Is the Skill for Jack in Group C going to show the number for Jack with Skill XAX or is the Skill column supposed to show the average for the KPI for Jack and Paul in Jack's "row" and Paul's "row"? Or something else entirely?
- MathieuF
I have an "Agent" segment.
I want when I select an agent, I can see in the table the value of their indicator, that of their team and that of their area of expertise.
For example, Pierre is from team A and skill XAX.
So for KPI1, I should have:
Agent: 10
Team: 10
Skill: Avg(10+25): Peter and Paul have the same area of expertise.
I hope that it's clearer.For information, on my original file I calculate my indicators via a filter FILTER(ALL(team),
team[Agent] = SELECTEDVALUE(Team[Agent])