Admin Setup

Kibana Configuration

Introduction

This page contains examples of configurations for Kibana visualizations. The examples use a Vertical Bar Chart, which is the most versatile type of graph Kibana offers. This guide always includes an Index specification (which index should be chosen). If no results appear even with the correct setup, please check that the time period is correct.

Most Translated Language Pairs

Configuration:

  • Index: analytics.data.job
  • Metrics: Sum of data.volume.words
  • Buckets: X-Axis - Terms - job.languagePair

Most Expensive Projects

Configuration:

  • Index: analytics.data.costs
  • Metrics: Sum of data.total
  • Buckets: X-Axis - Terms - project.id

Costs Per Linguist

Configuration:

  • Index: analytics.data.costs
  • Metrics: Sum of data total¨
  • Buckets: X-Axis - Terms - jobPart.assignedTo.linguist.fullName.untouched
  • Filter: quote.tags:"com.memsource.costs.jobPart.raw" - creates a chart without NetRate applied.
  • Filter: quote.tags:"com.memsource.costs.jobPart" - creates a chart with NetRate applied.

Costs Per Vendor

Configuration:

  • Index: analytics.data.costs
  • Metrics: Sum of data total
  • Buckets: X-Axis - Terms - jobPart.assignedTo.vendor.token
  • Filter: quote.tags:"com.memsource.costs.jobPart.raw" - creates a chart without NetRate applied.
  • Filter: quote.tags:"com.memsource.costs.jobPart" - creates a chart with NetRate applied.

Expected Wordcount vs. Net Number of Words

Configuration:

  • Index: analytics.data.analysis
  • Metrics: Sum of data.total.words
  • Buckets: X-Axis - Terms - jobPart.assignedTo.linguist.fullName.untouched
  • Split bars: Sub Aggregation - Filters
    • Filter 1: analysis.tags:"com.memsource.analysis.jobPart.raw"
    • Filter 2: analysis.tags:"com.memsource.analysis.jobPart"

Monthly TM Leverage

Configuration:

  • Index: analytics.data.analysis
  • Metrics: Sum of data.tm.match.101.words (Enter any match rates from the list. See THE example configuration below for more details.)
  • Buckets: X-Axis - Date Histogram - Monthly

Projects Created Monthly

Configuration:

  • Index: analytics.data.job
  • Metrics: Unique Count of project.id
  • Buckets: X-Axis - Date Histogram - project.dateCreated - Monthly

Projects Created in Specific Month Sorted by PM

Configuration:

  • Index: analytics.data.job
  • Metrics: Unique Count of project.id
  • Buckets: X-Axis - Date Range - project.dateCreated - dates (in form YYYY-MM-DD)
  • Split charts: Sub Aggregation - Tems
  • Field: job.createdBy.fullName.untouched
  • Order: Top - 0
  • Orderby: metric: Unique count of project.id