Users Data not linking

[Manni_SM]

Hi All, @rubenmarin 

in  operation monitor dashboard all data is restricted but not in user table data is not looking  due to data not in sync . 

my tables is lined with userid  with different format    like some text and right side   below is data 

Table1   ,                      Table 2

userID                             User ID 

hbap\245362                    3452648

hbeu\352727                    5375828

        563836                     hbap\345274

        453739                     hbeu\546896

i tried this but not working 

num(SubField(userId,'\',2)) as UserId,

[rubenmarin · Accepted solution]

Hi @Manni_SM, but only 5 lower than 30, wich confirms that the condition "Where floor(num(LogEntryPeriodStart))>=Floor(Today()-30)" reduces the users to 5.

[Manni_SM]

thanks @rubenmarin  yes its correct that 5records only will show.