In a PushMetrics notebook, you can use many different block types.
Some of them are executable and others simply display text or images.
+ button next to any existing block to toggle the
Add Block Menu.
From the menu, select the block type you want to create.
Use SQL tasks to write SQL and query almost any SQL database.
With the Tableau Export, you can download images, CSV, PDF, Powerpoint, and Crosstab XLSX files from Tableau Server or Tableau Online.
Use OpenAI's GPT models to create dynamic prompts and use the response in subsequent tasks.
API blocks can be used to send any HTTP
DELETE request to any RESTful API endpoint. This can be used for both sending and receiving data.
Send Emails using the Email block. Send to any email adress, use dynamic merge tags, and include attachments.
Similar to the Email block, you can send Slack messages and files to any channel using the Slack block.
With database writeback you can very easily write data from SQL query results, API responses, or CSV files into your database.
Parameters are simple named values that you may reference in other blocks as needed. You can choose to have a free input or define values that will be available from a drop-down menu.
Using if else logic in your Notebook will serve as control structure when the entire Notebook is executed. The condition will be evaluated and only the tasks inside the part that is true will be executed.
Similar to the IF/ ELSE logic above, for-loops serve as a control structure that is evaluated when the entire notebook is executed. You may use a for loop to iterate over query results, API responses, or simple lists.
The Chart block allows you to visualize your data in a variety of ways, including bar charts, line charts, area charts, and more.
You can use data from SQL queries and customize the chart's appearance to suit your needs.
Text blocks are used to add notes, explanations, or any other text content to your notebook. They support markdown for formatting, so you can easily add headings, lists, links, and more.
The following types are supported:
The Image block allows you to add images to your notebook. You can paste an image from your clipboard or insert a link to an image on the web.
The Media Embed block allows you to embed videos, audio, and other media content in your notebook. You simply paste the URL of the media you want to embed, and it will be displayed in your notebook.
The Divider Line block is used to visually separate different sections of your notebook. It inserts a horizontal line across the page.