I have an elastic document Action(task_id, username, time_spent_seconds, action_start_time, action_end_time, action_type). How can i create a kibana visualization to show the top average(per task) times of users. Currently i have a pie chart that is sliced by username, and sized by average(time_spent_seconds). But this is the average per Action and not per task. Is this possible?
Elastic/Kibana group and average by multiple fields
80 Views Asked by user19536467 At
1
There are 1 best solutions below
Related Questions in ELASTICSEARCH
- How does Elasticsearch do attribute filtering during knn (vector-based) retrieval?
- Elastic python to extract last 1hr tracing
- Elastic search not giving result when Hyphen is used in search text
- FluentD / Fluent-Bit: Concatenate multiple lines of log files and generate one JSON record for all key-value from each line
- Elasticsearch functional_score with parameter of type string array as input not working
- Elasticsearch - cascading http inputs from Airflow API
- AWS Opensearch - Restore snapshot - Failed to parse object: unknown field [uuid] found
- cluster block exception for system index of kibana
- What settings are best for elasticsearch query to find full word and half word
- OpenSearch - Bulk inserting Million rows from Pandas dataframe
- unable access to kibana
- PySpark elastic load fail with error SparkContext is stopping with exitCode 0
- How to use query combined to KNN with ElasticSearch?
- Facing logstash compatibility issues
- If the same document is ingested at two different times, how to have the same id in Elasticsearch
Related Questions in KIBANA
- Elastic python to extract last 1hr tracing
- cluster block exception for system index of kibana
- unable to serialize JSON type logs In fluentd(logging-operator)
- unable access to kibana
- How to Create a Data Table Visualization in Kibana with Nested Aggregation Fields?
- Kibana/Logstash not extracting data with grok pattern
- How do I designate an index as log data?
- Find kibana api uri and port
- Elasticsearch: Problem when I try to add dinamically nested objects into filter using c#
- How to setup security on elasticsearch based on redhat image in openshift
- Not able to parse logs having spaces between key value pair in json
- Kibana Watcher: Aggregation not working if only one hit by query
- How to create advance kibana visualisation
- How to get new error log occurrences in last 7 days in Kibana
- Opensearch - parse the log in Kibana and extract the values with alias names
Related Questions in KIBANA-7
- How to get new error log occurrences in last 7 days in Kibana
- Isn't possible using nested data types (of Elastic Search) inside Kibana?
- Can kibana enable automatic monthly auto-creation of indexes for different spaces?
- Kibana text field in discover but missing in lens table
- How to Create Email Alerts for Tracking Untracked Hosts on Kibana?
- How to create a metric that shows the average record count per day of year?
- Display logs in a specific order on Kibana visualization
- Query a nested object in elastic in kibana and display it to a table
- Fluentd configuration for creating elasticsearch indices
- Can the Kibana interface be grouped for projects?
- Creating Mappings for Index Interconnections in ElasticSearch: How to Establish Relationships Between Tables?
- Logging: Kibana integration with FluentD and Elasticsearch - how to integrate (Kubernetes) in a test environment?
- Getting access to custom headers in kibana client
- Kibana Default Index pattern is changing automatically after being set for Multiple times
- kibana data table aggregate but no by all the fields
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Did this by sizing with formula
sum(time_spent_seconds) / unique_count(task_id)