Each category has data (like the screenshot). However, when I apply a filter to see only one year, the table looks blank, even though when all the categories are there it shows something...
What could it be?
Hi, thanks for the quick answer!
Originaly the field was long, so I changed it before indexing to keyword, but still it wouldn't work.
Then I considered for the table using the date and YYYY, but still when I would use the control year (keywork) it would show empty in some occasions...
Also, I noticed than when I filter by date, the table also shows blank (no filters selected, just the dashboard time).
which field you have selected as @timestamp in data view.
check your condition if you correctly extracted year value of that date field and saved in new_date_field you can use runtime field or any method you like to do that.
there is no empty field in the new_date if there is then you have some issue in the logic.
value of new_date_field "2024" it should saved like this as keyword.
consider sharing the screen shot data example so we can do debug on this
Hi! I did what you suggested, but still it doesn't work. The data view is linked to the field 'date_observed' (and it literally is the only date field in the index).
On this picture, you can see that the year matches the 'long' field (I prefered it over keyword, and have the same issue if it's keyword).
I extracted the year value in python and have it in long and keyword just in case.
There are no empty fields.
Within the lens editor if I filter by selecting the year, it shows things, but if I filter by the time it looks blank (I know the specific date and regardless it looks empty...).
The other lenses do filter and show info when filtered by year category or by time range.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.