Hi Team,
we have index where sorting is done based on modified_date instead of @timestamp. we have selected the same in time filter as well.
now when we are trying to create a visualization in Canvas, its throwing error and doesnt show any field in measure section.
the moment i change time filter to @timestamp, it get fixed. however, @timestamp will not work for us as our calculations are based on modified_date. We need the time filter to be working with modified date.
Any suggestion?