Recent Record in the table

[Anonymous]

Hi

I need to display the values in a chart where the datetime filed in the table is the most recent :

How do i write that in the expression of the chart,

For eg:

I have 2 columns in a table - end_time, no of users

I need to get number of users recently used the system where the end_time is the most recent time stamp.

Thanks

[#2]

For your example, type the following code in a text box:

right(concat([no of users],',' ,end_time), index(concat([no of users],',' ,end_time),',')-1)

[Anonymous]

Thank you for the reply..This code is displaying a comma in front of the value ..how can i avaoid this..

[Anonymous]

could anybody please help me, how do i write this expression in chart?

the above expression when written in a text box gives "," in front of the value.

I basically need a Gauge chart with LED setting ti display the number of users where end_time is max time.

[Miguel_Angel_Baeyens]

Hello,

Try something like

Count({< end_time = {"$(=Max(end_time))"} >} UserID)

Hope that helps.

[Anonymous]

I think i am not clear with my qyestion , i already have calculated data in my table , only thing i need is to display the no of users value in a chart with the max(end_time).

Basically users of the report what to see the number users at current time stamp , or recent time stamp in the table.

According to the below sample data ,

I want 2010-08-25 09:23:37 and 5 to be displayed in the chart.

Sample Data:

End_time	number_of_users
2010-08-25 09:23:37	5
2010-08-25 09:08:46	6
2010-08-25 08:53:46	10
2010-08-25 08:38:39	20

[montubhardwaj]

try something like this: =count(If((End_Time)=Max(End_Time),No of users))

hope that was helpful.

Regards,

Sharma

[Clever_Anjos]

Try this

Only({< end_time = {"$(=Max(end_time))"} >} UserID)

[Anonymous]

Thank you this workd..could you please let me know how do i display that time stamp also in the chart

i want to display something like below

2010-08-25 09:23:37

5

[Clever_Anjos]

have you tried Max()?