topic Re: Operation Rows in Discussions

Operation Rows

NetflixCrow956 — Fri, 09 Jun 2023 17:07:29 GMT

Hello everyone, I would like to know how to count the number of "OTPs" that are equal to 0 and make the division on the total number of LINES of OTP ? Thank you for your help

Re: Operation Rows

Ressel — Thu, 11 Aug 2022 13:05:11 GMT

Here's how you get the number of rows where OTP is equal to zero (see also here:(

dt = current data table () << select where (:OTP == 0); // suggest to have only the one table of interest for you open when testing this

num_selected = nrows(dt << get selected rows); // num_selected is now the number of rows where :OTP is equal to zero

Another way is via point & click:

Convert the OTP column to Data Type "Character" under Column Info.
Run a distribution analysis of the OTP column. This will show you how many rows with OTP equal to 0 there are.

Can you elaborate a little on the second part of the task, i.e., "...make the division on the total number of LINES of OTP."? I don't understand this. (Sorry.)

Re: Operation Rows

jthi — Fri, 12 Aug 2022 07:52:29 GMT

Create new formula column such as

:OTP == 0

then use summary to create new table using the new column as Subgroup (remove link to original data table if you don't need it)

select N Rows and N(1) columns and create new formula column with right click menu: