how to retrieve odd or even rows from the table?

[KHK]

Hi Team,

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

Regards,

HK

[RADSr · Accepted solution]

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.

[KHK]

HI ,

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

[RADSr · Accepted solution]

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.