# Create your own analytics visualizations

{% hint style="info" %}
Make sure to have reviewed [Configure your OpenSearch](/idea/best-practices/analytics/opensearch/configure-your-opensearch.md)
{% endhint %}

Click the hamburger menu to reveal the left sidebar then click "**Visualize**" under "**OpenSearch Dashboards**" section.&#x20;

Below are some example to help you get started:

<details>

<summary>(Scale-Out-Workloads) Money spent by instance type</summary>

* Select "Vertical Bars"
* Select the "scheduler\_jobs" index
* Y Axis (Metrics):
  * Aggregation: Sum
  * Field: estimated\_bom\_cost.line\_items\_total.amount
  * Custom Label: Cost
* X Axis (Buckets):
  * Aggregation: Terms
  * Field: params.instance\_types\_raw
  * Order By: metric: Cost
  * Size (adjust as needed): 20
  * Custom Label: Instance Type
* Split Series (Buckets):
  * Sub Aggregation: Terms
  * Field: params.instance\_types\_raw
  * Order By: metric: Sum of Cost
  * Size (adjust as needed): 20

Example (click to enlarge):

![](/files/NI0BzgVJg4Tchqquv9PX)

</details>

<details>

<summary>(Scale-Out-Workloads) Jobs per user</summary>

* Select "Vertical Bars"&#x20;
* Select "scheduler\_jobs\*" index
* Y Axis (Metrics)
  * Aggregation: count
* X Axis (Buckets):
  * Aggregation: Terms
  * Field: owner.raw
  * Size (adjust as needed): 20
* Split Series (Buckets):
  * Sub Aggregation: Terms
  * Field: owner.raw
  * Order By: metric: count
  * Size (adjust as needed): 20

Example (click to enlarge):

![](/files/btf5yPDbJRyjlLR2a4FC)

</details>

<details>

<summary>(Scale-Out-Workloads) Jobs per user grouped by instance type</summary>

* Select "Vertical Bars"
* Select "scheduler\_jobs" index
* &#x20;Y Axis (Metrics):
  * Aggregation: count
* X Axis (Buckets):
  * Aggregation: Terms
  * Field: owner.raw
  * Order By: metric: Count
  * Size (adjust as needed): 20
* Split Series (Buckets)
  * Sub Aggregation: Terms
  * Field: params.instance\_types.raw
  * Order By: metric: Count
  * Size (adjust as needed): 20

Example (click to enlarge):

![](/files/4KpAAVWeP8Df1dmQeWCL)

</details>

<details>

<summary>(Scale-Out-Workloads) Instance type launched by user</summary>

* Select "Heat Map"
* Select "scheduler\_jobs" index
* Value (Metrics):
  * Aggregation: Count
* Y Axis (Buckets):
  * Aggregation: Term
  * Field: params.instance\_types.raw
  * Order By: metric: count
  * Size (adjust as needed): 20
* X Axis (Buckets)
  * Sub Aggregation: Terms
  * Field: owner.raw
  * Order By: metric: count
  * Size (adjust as needed: 20

Example (click to enlarge):

![](/files/vxQY2aMu2txKcO42aIxs)

</details>

<details>

<summary>(Scale-Out Workloads) Number of nodes in the cluster</summary>

* Select "Lines"
* Select "scheduler\_nodes\*" index
* Y Axis (Metrics):
  * Aggregation: Unique Count
  * Field: instance\_id
* X Axis (Bucket)
  * Aggregation: Date Histogram
  * Field: provisioning\_time
  * Interval: Minute

Example (click to enlarge):

![](/files/VMbot1lRq5kh3BE5z8Ah)

</details>

<details>

<summary>(Scale-Out-Workloads) Detailed Information per user</summary>

* Select "Datatables"
* Select "scheduler\_jobs" as index
* Metric (Metrics):
  * Aggregation: Count
* Split Rows (Buckets):
  * Aggregation: Term
  * Field: owner.raw
  * Order By: metric: Count
  * Size (adjust as needed): 20
* Split Rows (Buckets):
  * Aggregation: Term
  * Field: params.instance\_type.raw
  * Order By: metric: Count
  * Size (adjust as needed): 20
* Split Rows (Buckets):
  * Aggregation: Term
  * Field: estimated\_bom\_cos&#x74;*.*&#x74;ota&#x6C;*.*&#x61;mount
  * Order By: metric: Count
  * Size (adjust as needed): 20

Example (click to enlarge):

![](/files/SnKMKeLG43cXmrvHzQbG)

</details>

<details>

<summary>(VDI) Most active VDI users</summary>

* Select "Pie"
* Select "vdc\_users\_sessions\*" index
* Metrics:
  * Slice Size: Count
* Split Slices (Buckets):
  * Aggregation: Terms
  * Field: owner.raw
  * Order By: metric: count
  * Size (adjust as needed): 20

Example (click to enlarge):

![](/files/L2stZm384K3AKdHBAdeR)

</details>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ide-on-aws.com/idea/best-practices/analytics/opensearch/create-your-own-analytics-visualizations.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
