topic Re: Dashboard Table - Filter out columns instead of entries in ArcGIS Online Questions

Dashboard Table - Filter out columns instead of entries

AbigailEbelherr — Tue, 10 Oct 2023 16:34:22 GMT

I am wondering if there is a method of filtering out null columns in the Table widget on the dashboard and not the whole entry. I have features on a map, and some of them have funding for two years while others have funding for three years. When I select the ones that only have two years of funding, I want only those two years to be shown rather than the blank third year:

I need the Funding Year 3 column added to the table for those features that do have a third year, so I cannot remove it from the table. When I try to use the filter options, it just removes the whole feature if Funding Year 3 is null instead of the column.

Any help is greatly appreciated.

Re: Dashboard Table - Filter out columns instead of entries

MobiusSnake — Tue, 10 Oct 2023 17:06:22 GMT

I don't think there's a way to do this, but there might be a reasonably clean alternative.

You could use a Data Expression (written in Arcade) to convert your records to 2-or-3 distinct records, depending on whether it has two or three years' funding.

For example, if you had a record like this:

Year1	Src1	Amount1	Year2	Src2	Amount2	Year3	Src3	Amount3
2024	A	10000	2025	B	15000	2026	C	20000

You could convert it to this:

Year	Src	Amount
2024	A	10000
2025	B	15000
2026	C	20000

Whereas if you only had the first six columns in your record, you'd end up with two rows in your result.

I think this would give your table a nice appearance, no gaping blank spaces, but how easy it will be will depend on how familiar with Arcade you are.

Re: Dashboard Table - Filter out columns instead of entries

AbigailEbelherr — Mon, 16 Oct 2023 21:30:26 GMT

Thank you for offering a solution. I am not very familiar with Arcade. We decided to go in a different direction with displaying the data, so this won't be needed for now, but I appreciate the help.