I'm pulling in stats data via CSV file. I am using a specific column header "LoginTime" as the Date field
I've timecharted to look at the distinct Usernames over a period of time.
base search |timechart dc(Username)
However, the results are doubling up due to _time results which are also showing in unix time.
for e.g
a Username result is found with the Date field result 01/08/2018 22:22:14
and the _time result is 2018-08-31T22:37:50.000+01:00 in the same event.
A timechart period 'All time' outputs this as 2 results:
a result for 31st August and _time result as 2018-01-08T22:22:14.000+00:00
can I switch the _time to display the timechart results as day, month, year? NOT year, day, month.
... View more