SaaS Reporting Tutorial Entity Metrics Worksheet

We'll show an example of how to create a query referencing data from the "Entity Metrics Worksheet". Specifically, we'll create an Answer that shows the top 50 most utilized VMs by vMem 95th percentile.

1. Login to Thoughtspot.
2. Click on the Search data button on the top.
   
3. On the left, locate the Sources section. Click on the wrench to select a source.
   
4. In the Worksheets section, check the box for the Entity Metrics worksheet. Click Done.
   
5. Let's add some filters first to help speed up the query.
   1. On the left-hand side, hover your mouse over Time and click the filter icon.
      
   2. From the drop-down, select Last. Then fill out 30 and Days. Click Apply.
      
   3. In the query bar at the top, type virtual_machine. A drop-down will appear with suggested filters, click the virtual_machine for Entity Type in Entity Metrics.
   4. In the query bar at the top, type vmem. A drop-down will appear with suggested filters, click the vmem for Metrics Type in Entity Metrics.
6. Now let's add some columns to our query. On the left-hand side, double-click on the following columns to add them to the query box at the top:
   • Name - the name of the VM
   • Metric Type - the metric name
7. Now let's plot a few different utilization values.

   1. In the query bar at the top, type average Utilization. A drop-down will appear suggested values, click the Utilization from Entity Metrics.

   2. In the query bar at the top, type max Utilization. A drop-down will appear suggested values, click the Utilization from Entity Metrics.

   3. In the query bar at the top, type name. A drop-down will appear with suggested column, click the name for Entity Metrics.

   4. In the query bar at the top, type Metric Type. A drop-down will appear with suggested column, click the Metric Type for Entity Metrics.