Graphs
Teragrep creates graphs automatically after paragraph has run as long as the input contains an applicable database.
Each graph has its own set of controls at the top. You can also download your data either as a CSV or a TSV file.
Graph Options
On the left of graph controls are buttons for switching between different chart types. There are six options: table view, bar chart, pie chart, area chart, line chart and scatter chart.
Table View
In table view the data is generated into a table and sorted into columns based on the data.
By clicking the chevron next to columns name opens a drop-down menu with filtering options. You can sort table data to ascend or descend. You can change the data type (string, number or date) for the column. You can also aggregate the data with count, sum, min, max and avg.
By clicking the hamburger menu on the right you can hide table columns and export the table data in a csv or Excel file.
Bar Chart
In bar chart view the data is automatically generated into a bar chart. You can group or stack bars by clicking either Grouped or Stacked button.
You can view the bar’s exact value by hovering your cursor over it.
Pie Chart
In pie chart view the data is automatically generated into a pie chart. By hovering the pie chart you can view exact values.
Area Chart
In area chart view the data is automatically generated into an area chart. You can stack, stream or expand your area chart data by clicking either Stacked, Stream or Expanded buttons.
You can view exact values by hovering the area chart with your cursor.
Graph Settings
Graph settings can be expanded or collapsed by clicking the cog icon from the right edge.
Table Settings
In tables, you can enable filters, pagination or aggregation footer.
When pagination is enabled you can decide how many items are shown per page. The options are 25, 50, 100, 250 and 1000. When aggregation footer is enabled you can aggregate columns with values count, min, max and avg by clicking the chevron next to column’s name.
Bar Chart & Area Chart Settings
In bar chart and area chart settings there are three available fields: Keys, Groups and Values. You can freely drag and drop different values to different fields to create different graphs.
In Values field you can add either sum, count, avg, min or max to your values.
You can rotate or hide the x-axis in bar charts and area charts. The rotation degree value is -45 by default.
Pie Chart Settings
In pie chart settings there are three available fields: Keys, Groups and Values. You can freely drag and drop different values to different fields to create different graphs.
In Values field you can add either sum, count, avg, min or max to your values.
Line Chart Settings
In line chart settings there are three available fields: Keys, Groups and Values. You can freely drag and drop different values to different fields to create different graphs.
In Values field you can add either sum, count, avg, min or max to your values.
In line charts you can force the y-axis to 0, enable zoom or change the date format. By default, the date format is DD/MM/YYYY.
You can rotate or hide the x-axis in line charts. The rotation degree value is -45 by default.
