I was trying to create a report using DISCOVER menu.
The index got 8 million records and one of the fields is DeviceID
If I choose the 'exists' as filter and field DeviceID; I get all the 8 million records.
I want to limit this based on ranges, such as
DeviceID >10K and DeviceID <500K
How's it possible? I wanted to export that in to a csv then.
When I try to export without such a range, it seems like it's taking so much time (running for over 20 hours now). I'm unsure why (just a integer field 8 million records) taking over 20 hours plus for the csv export.