Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
amiroh81
Creator
Creator

Max record date

Hello All,

I have a table with multiple measures and column timestemp.

The data appear in intervals of 10 minutes.

I want to display only the values ​​listed in the table with the last interval.

I tried to build the table and chart style as well as table box and I could not do this with the command max (record_date (

Can anyone help me please?

Thanks in advance

5 Replies
Anonymous
Not applicable

I'm not sure what you want - but try
max(total record_date)
or
max (all record_date)

MK_QSL
MVP
MVP

Aggr(Max(TOTAL Record_Date),YourFieldName)

amiroh81
Creator
Creator
Author

Hi,

max(total record_date) work!

can you Explain me what is the total command please ?

thank you very much

Anonymous
Not applicable

The "total" qualifier in this case tells to disregard chart dimensions.  If you use "all" - it disregards dimensions and selections.
(See "help")

amiroh81
Creator
Creator
Author

Thank you very much.