cancel
Showing results for 
Search instead for 
Did you mean: 

how to retrieve odd or even rows from the table?

KHK
Partner
Partner

Hi Team,

please let me know how to retrieve odd or even rows from the table?

Regards,

HK

3 REPLIES 3

RADSr
Captain
Captain

Can you give a bit more context?   Is this random?  Does it depend upon ordering by a specific field?

A use case example would be helpful to get you the correct and best answer.

-- IncortaOne@PMsquare.com --

HI ,

If i want only odd numbers then only odd number rows should  retrieve from table

Drag a formula into the individual filter area of an insight.   You can use the MOD function to determine odd/even  e.g. 

mod(Date_US.Date_US.Day_Number, 2) = 0
 
Result e.g.  
RADSr_0-1674314682898.png

 

 

-- IncortaOne@PMsquare.com --