Straight Table Chart - Forced Field

[#1]

Hi,

The attached screenshot shows a page I have mocked up. In the bottom right corner is a Straight Table chart called Form Guide. You can see that I currently have Team = "West Ham" selected. Can you please advise how I can force the straight table to always display data when the Team field in this table = West Ham. I have tried a few conditional formats but they make the data disappear unless I manually select the team. I would like the table forced to display all data for a certain team. Is this possible?

[prabhu0505]

Share the mocked up dashboard.

[Anonymous · Accepted solution]

Add Set Analysis in the Straight Table expression to force it to only evaluate for West Ham, maybe something like :

     = only ( {<Team={'West Ham'}>} Form)

[#4]

Many thanks Bill, that's perfect !