topic How to get previous date values in the dashboard table apart from event data? in Getting Data In

How to get previous date values in the dashboard table apart from event data?

sekhar463 — Thu, 01 Jun 2023 13:58:43 GMT

i have data in the event with date field

and while saving the same search in the dashboard studio table its giving previous date values

not giving exact values as event data

index=test sourcetype="test Data*"
| sort -time
| dedup TABLE_NAME
| table TABLE_NAME MAX_POSITION_DATE MAX_DMA_RUN_DATETIME

TABLE_NAME MAX_POSITION_DATE MAX_DMA_RUN_DATETIME
5858585 L 2023-06-01 00:00:00.000 2023-06-01 06:48:12.225
46466464 2023-05-31 00:00:00.000 2023-06-01 03:02:58.000

Re: Getting previous date values in the dashboard table apart from event data

ITWhisperer — Thu, 01 Jun 2023 10:24:46 GMT

Assuming your time field is a numeric timestamp, the sort will put the events in descending time order i.e. latest first. The dedup will keep the first event in the pipeline for each table name.

Without seeing the exact data you are dealing with, it is not possible to say whether the values you are showing are correct or not, but given the above assumptions, if you are not getting the data you are expecting, you should look closer at your actual data to determine where the discrepancy may have arisen from.