Two variables in my dataset are important for this question namely : "Country_code" and "Tunnel_status". See example
Country_Code Tunnel_status
BE Up
NL Up
FR Down
BE Up
NL Up
FR Down
BE Up
NL Down
FR Up
What I wanted do to now is the following : the availability in BE was 100%, the one in NL was 66% and the one in FR was 33%. I want to filter on the countries with an availability lower then 33% so keep only France. The way how it is visualised is not so important for me, it should just be easy to see and to filter on the country codes with an availability lower then 33%.
Alternatively, you could visualize this data and sort by availability ascending, but you would still see all of the data (even that above 33%) in the visualization.
First of all thank you for your answer, currently I'm doing this task in a Heatmap.
Metrics
Y-Axis
Aggregation : count
Buckets
Split chart
Aggregation : terms
Field : VPN_BOX_LOCATION
X-axis
Sub aggregation : Date Histogram
Field : @Timestamp
-Split series
Sub aggregation
Field : Tunnel_Status
And then I have selected in Metrics and aces -> Y)aces -> mode percentages. This gives me a nice view but if I click on order by then it orders based on the count of occurences in a country and not on the percentage.
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.