SaaS Reporting Tutorial Action Worksheet

We'll show an example of how to create a query referencing data from the "Actions Worksheet". Specifically, we'll create an Answer that shows the actions Turbo has executed over the past 30 days.

1. Login to Thoughtspot.
2. Click on the Search data button on the top.
   
3. On the left, click on Select a Data Source.
   
4. Locate the Actions worksheet and click Select.
   
5. Let's add some filters first to help speed up the query.
   1. On the left-hand side, hover your mouse over Datetime (UTC) and click the filter icon.
      
   2. From the drop-down, select Last. Then fill out 30 and Days. Click Apply.
      
   3. On the left-hand side, hover your mouse over State and click the filter icon.
      
   4. A list of possible "states" will appear. Check the box for SUCCEEDED. Click Apply.
      
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:
   • Datetime (UTC) - when an action was executed
   • Description - a brief description of what the action was
   • Type - the type of action taken (move, resize, delete, etc)
   • Entity Type - the entity the action was taken on (vm, container pod, volume, etc)
   • Environment - the environment where the entity lives (cloud, on-prem, hybrid)
     
   
7. To run the query, click Go in the top right corner. Data should now populate in the table showing all the actions that succeeded in the last 30 days.
   
8. By default, the Datetime (UTC) is showing the data by Month-Year. Let's change that to show the day the action was executed. In the query bar at the top, type daily and click Go.
   
9. In order to visualize this data, we need to add a metric. In the query bar at the top, type unique count id and click Go.
   
10. Now let's take these query and add a visualization. Click on the View Chart icon beneath the query bar.
    
11. A default visualization will appear. Let's make some modifications. Click on the Change visualization icon on the right.
    
12. Select Stacked Column.
    
13. Click on the Edit chart configuration (gear) button on the right.
    
14. Drag the entities according to the following organization:
    • X-axis:
      • Daily Datetime (UTC)
    • Y-axis:
      • Unique Count Id
    • Slice with color:
      • Environment
      • Entity Type
      • Type
    • Not visualized
      • Description
        
    
15. Click Apply
16. Your query and visualization are complete! You can now see the trend of executed actions over the last 30 days organized by Environment, Entity Type, and Action Type.
    
17. Now let's save this visualization (ThoughtSpot terminology: "Answer"). Click on the More icon (three dots) and select Save.
    
18. Provide a Name and Description for your visualization and then click Save Answer.
    • Name: Action Execution Trend
    • Description: Actions executed in the last 30 days organized by Environment, Entity Type, and Action Type.