display only the last measure

[#1]

Hello,

I am using a QV template (QV11) using an excel file source. I have several chart in this template showing different measurement per equipment. Actually, I would like to have all the chart only showing the last measurement and not all.

I can filter by date and hour but would like an automatic formulation for getting the last measure ?

Please, could you help me about QV configuration to be able to do it ? Do I need to create a script or special expression ?

Thanks in advance for your help ?

Regards,

[swuehl]

You could create a search in your timestamp field to find the max value, then bookmark the search.

If you want to fix all charts to only show the latest value:

- Either limit your load script to only load the latest value (since loading the older data wouldn't show benefit then?)

- or use a filter using set analysis in all your charts, all your aggregation functions.

Which path do you want to follow?

[#3]

Hello swuehl,

Thanks for your reply.

What do you mean by:  "create a search in your timestamp field to find the max value, then bookmark the search"

Could you explain more in details about use a filter using set analysis in all your charts, all your aggregation functions.

Thanks in advance,

Matt

[#4]

Please help me to get the right expression ?

I already found for the date (see below)

=date(Max(if(machine='A',DATE,)))

But I would like to add another max value wich is hours. I do not know how to add it in this expression ?

Please could you help me

Matt

[sunny_talwar]

Do you have a TimeStamp field in your database? or are you working with Date and Time as different fields?

[swuehl]

Right, If you want to find the max date & time (as combination, not the max of each separately), you should create a timestamp field in your data model and find the max timestamp value.

Could you describe more how your data model looks right now?

[#7]

Hello,

In fact, I have this kind of field into my database (machineA_2016-01-03_15.49.33) where date and time are extrated with this function:

mid(Filename,21,8)as HOURS,

mid(Filename,10,10)as DATE,

Since I have several measurement for this machine at the same date, I would like a additional filter with Hours.

Please help me

[#8]

Dear community,

Please help me to find the right expression or script following above indications ?

Thanks in advance,

[oknotsen]

Please respond to Stefan Wuhl's question, found right above your latest reply.

[#10]

Hello,

I only have a Filename field in my database where I can find date & time values (machineA_2016-01-03_15.49.33.DDF.

I extracted the date & hours with this function:

mid(Filename,21,8)as HOURS,

mid(Filename,10,10)as DATE

I have created two selection list where i get date and time but each time I need to select manually the last Date and time. For each chart into my template I would like to have selection of the last date and time for each machine.

Could you help me for writing the right script or expression in the chart

Thanks in advance,

Matthew