topic Re: Show / Hide in Straight Table (Chart Exploration) in App Development

Show / Hide in Straight Table (Chart Exploration)

prads_uk_2025 — Fri, 12 Sep 2025 14:38:56 GMT

Hey All,
Requirement: The column / Measure : Only([Mark Date]) should be displayed only when Asset Name and Asset IDs are selected from the Straight Table's chart exploration.
I tried Count([Asset Name]) > 0
, GetSelectedCount([Asset Name]) >= 1
nothing works

Need guidance here.

Re: Show / Hide in Straight Table (Chart Exploration)

MatheusC — Fri, 12 Sep 2025 18:10:31 GMT

Hi,

From what I understand, the rule is that both fields must be selected for the correct field/measurement to appear?

That should be enough.

GetSelectedCount([Asset Name]) > 0
and GetSelectedCount([Asset ID]) >0

- Regards, Matheus

Re: Show / Hide in Straight Table (Chart Exploration)

robert_mika — Sat, 13 Sep 2025 05:00:18 GMT

only from this table or overall selections as @MatheusC solution ?

Re: Show / Hide in Straight Table (Chart Exploration)

prads_uk_2025 — Sat, 13 Sep 2025 09:48:44 GMT

The solution is required for both the fields however, if it work for one it would work for other using AND/OR.
Count and GetselectedCount is not working in this case because it is just selection / deselection which itself in playing hide/seek.

Re: Show / Hide in Straight Table (Chart Exploration)

prads_uk_2025 — Sat, 13 Sep 2025 09:49:00 GMT

It should be field specific not table

Re: Show / Hide in Straight Table (Chart Exploration)

MatheusC — Mon, 15 Sep 2025 20:02:46 GMT

OK, you can test this approach. It's an alternative for this scenario, though not as practical.

GetObjectDimension() – will return the dimension.

if(match('[Asset Name]',GetObjectDimension(0),GetObjectDimension(1),GetObjectDimension(2),others...),1,0)

In other words, the expression will search for your dimension ( '[Asset Name]' ) if it's present among the columns in your report passed in index().

- Regards, Matheus

Re: Show / Hide in Straight Table (Chart Exploration)

prads_uk_2025 — Tue, 16 Sep 2025 08:18:22 GMT

Thank you so much for the logic.

=if(GetObjectDimension(4)='Asset Name',1,0)

This worked. I was using GetObjectField but above one seems easy peasy.

Re: Show / Hide in Straight Table (Chart Exploration)

MatheusC — Tue, 16 Sep 2025 12:17:19 GMT

Good that it worked for your scenario, just be careful if the column is not static, it will be necessary to add the other indexes so that it does not lose dimension if the position changes.

Regards, Matheus

Re: Show / Hide in Straight Table (Chart Exploration)

prads_uk_2025 — Tue, 16 Sep 2025 12:29:42 GMT

Yes, I deduce that and so you solution works best however, the positions of those 2 dimensions are fixed so won't be an issue. Thank you once again for this amazing solution.