topic Re: Table visualization - same row displaying twice in App Development

Table visualization - same row displaying twice

jerryr125 — Sat, 16 Nov 2024 00:18:13 GMT

Hi - I have a table visualization showing the following (as an example):

Location Quantity Comments

------------- ------------ ----------------

LOC01 100 -

LOC02 2000 -

LOC03 545 quantity from abc inc.

LOC03 545 -

The 'comments' is in another table (one occurrence BUT not every location has a comment).

Since LOC03 has a value in the 'comments' fields, it is now displaying twice in my visualization (as seen above).

How can I remove the second occurrence of LOC03 and still keep LOC01, LOC02, and LOC03 in the table visualization ?

Therefore, the outcome would be :

Location Quantity Comments

------------- ------------ ----------------

LOC01 100 -

LOC02 2000 -

LOC03 545 quantity from abc inc.

Also, the comments fields is a dimension since I am using an if statement to pull the comments from another table.

It works fine - the issue is the appearance of the second occurrence.

Thanks - Jerry

Re: Table visualization - same row displaying twice

jerryr125 — Wed, 07 Apr 2021 12:46:42 GMT

Hi - any thoughts on this ? Thanks - Jerry

Re: Table visualization - same row displaying twice

Gysbert_Wassenaar — Wed, 07 Apr 2021 13:22:21 GMT

Well, the rows are not duplicates because they differ. One has a value in the Comments field and the other does not. If you want only one row you will have to use a measure that aggregates the values in the Comments field. Perhaps MaxString(Comments) works for you.

Re: Table visualization - same row displaying twice

jerryr125 — Wed, 07 Apr 2021 13:31:53 GMT

Hi -

I currently have in the column (dimension) the following formula:

=IF([materialid]='mat01',(comment))

If I add MaxString to the formula (again, in a column that is a dimension):

=IF([materialid]='mat01',MaxString(comment))

I get an error - invalid dimension

Re: Table visualization - same row displaying twice

jerryr125 — Wed, 07 Apr 2021 13:36:04 GMT

I tried this as well:

=IF([intrppematerialid]='ppemat01',aggr(maxstring(intrcomment),intrcomment))

no luck - same results - thoughts ?

Re: Table visualization - same row displaying twice

Gysbert_Wassenaar — Wed, 07 Apr 2021 15:57:34 GMT

Try removing the dimension and adding a measure.

Re: Table visualization - same row displaying twice

jerryr125 — Wed, 07 Apr 2021 16:31:54 GMT

Hi I removed the dimension and added the following as a measure:

=IF([intrppematerialid]='ppemat01',aggr(minstring(intrcomment),intrcomment))

Still no luck

Re: Table visualization - same row displaying twice

Dalton_Ruer — Wed, 07 Apr 2021 19:35:07 GMT

Simply use MaxString(Comments) as the expression for the comments field unless there is some reason you literally only want to only show that particular location one time but if the others had multiple comments you would want to see them.