topic Re: Quantifying how many rows selected in Discussions

Quantifying how many rows selected

CSSanderson — Sat, 10 Jun 2023 20:51:25 GMT

This has to be possible... Is there an easy way to quantify the number of rows selected (and ideally the percent of rows selected) and display it on a dashboard? I know that I can go back to the raw data table and see the number Selected in the Rows area - I'd like to pull that onto a dashboard...

Specific example - here's gas flow through a panel data. How many cells are highlighted as a fraction of the total?

I can go back to the data table and see that it's 2270 rows, so the data's available... I'd just like to put it on the dashboard

Thanks in advance

Charles

Re: Quantifying how many rows selected

jthi — Mon, 18 Jul 2022 16:35:55 GMT

One option is to create formula column with following formula to get 1 when column is selected.

Selected()

If you only care about total you can then count them from that formula column or possibly use Col Sum directly in the formula

Col Sum(Selected())

See for more fancy uses for special formula columns like that.

Other option is to use Row State Handler (or Graphic Script) with something like:

N Items(Current data Table() << Get Selected Rows)

Re: Quantifying how many rows selected

CSSanderson — Mon, 18 Jul 2022 16:49:19 GMT

Thanks for that suggestion... I'm being dumb, though... How do I put that on my dashboard as an element that provides the summary statistic there (without having to go back to the data table)

Re: Quantifying how many rows selected

jthi — Mon, 18 Jul 2022 16:55:12 GMT

I don't really use Dashboards (I build my own windows) so I don't know if this is the only method.. but I think you can create new element with some platform (Graph Builder, Tabulate comes to my mind) and then add that to the dashboard. Here is very very quick example with Tabulate using the Selected() formula in column called Rows Selected

Re: Quantifying how many rows selected

txnelson — Mon, 18 Jul 2022 17:53:26 GMT

The percent selected would simply be

dt=current data table();
percentSelected = N Items( dt << get selected rows ) / N Rows( dt );