Charting & Data Tables

Visualize query results with a range of chart types and data tables, and easily export to Google Sheets, Microsoft Excel, Google Slides, Microsoft Powerpoint, Teams, Slack, and more.

Zing will automatically display the data in a way that makes sense for the data you selected. For instance, if you havetime as field in your question, Zing will automatically plot time on the x-axis from low to high. You can easily change to an alternative visualization if you wish, and can re-order data points, as described below.

If a question does not have a visualization which can be displayed (e.g. a table of text fields), Zing will simply show a table of results. Custom queries (where you provide SQL instead of using Zing’s tap-to-quuery interface) will display results using a table.

Visualization Types

Zing offers an range of visualization types, which vary based on the number of fields (and field type) returned in your question’s answer:

  • Bar Chart
  • Stacked Bar Chart
  • Grouped Bar Chart
  • Line Chart
  • Area Chart
  • Donut Chart

Toggle between chart types and data tables by tapping the upper right Chart Selection drop down

Tap on a data point in a chart to see a tooltip showing with the value of that data point and its category.

On iOS and Android, you can pinch-to-zoom into specific values or part of a graph.

Sorting

You can easily change the order values are displayed on the graph or data table.

To sort a graph, tap the x-axis and a ‘sort by’ controls will appear below your chart. You can sort by the x-axis, or y-axis from ascending or descending order.

To sort a data table, tap the field name and it toggle between unsorted, descending, and ascending.

Time and Date Formatting

To change the time and date formatting, tap the x-axis or a table cell, and formatting options will appear in the bottom sheet. Tap on the “Date format” dropdown to choose your preferred formatting options. The options you see will match the time granularity of your question.

If you choose the “custom” option, you can construct a custom format with the following symbols:

Symbol Meaning Presentation Example
y year number without truncation or leading zeros 2012
yy year number truncated to the last two digits 12
yyyy year four-digit number, with leading zeros if necessary 2012
M month in year number without a leading zero 3
MM month in year two-digit number, with a leading zero if necessary 03
MMM month in year abbreviated name Mar
MMMM month in year full name March
d day in month number without a leading zero 6
dd day in month two-digit number, with a leading zero if necessary 06
EEE day of week abbreviated name Tue
EEEE day of week full name Tuesday
h hour in am/pm (1~12) number without a leading zero 1
hh hour in am/pm (1~12) two-digit number, with a leading zero if necessary 01
H hour in day (0~23) number without a leading zero 13
HH hour in day (0~23) two-digit number, with a leading zero if necessary 13
m minute in hour number without a leading zero 7
mm minute in hour two-digit number, with a leading zero if necessary 07
ss second in minute number without a leading zero 55
ss second in minute two-digit number, with a leading zero if necessary 55
a am/pm marker PM
' escape for text ‘Date=’
'’ single quote ‘o’‘clock’

You can use characters like ‘/’, ‘:’, ‘-’, ‘.’ directly, without enclosing them in single quotes.

Exporting Graphs and Data Tables

Save graphs to your phone’s photo gallery by tapping the three dots in the top right of the app and click ‘save to photo gallery’. You may need to grant Zing permissions to save files to your phone. These images will be saved as PNGs and can be accessed by other apps on your phone to make it easy to send charts and analysis in email, Slack, and to embed in documents from your mobile device. Easily drop these graphs into Slack, Microsoft Teams, Google Slides, Microsoft Powerpoint, Microsoft Word, or Google Docs.

Save tables to your phone by tapping the three dots in the top right of the app and click ‘save table as CSV’. You may need to grant Zing permissions to save files to your phone. This will provide a comma seperated values file which can be used in other apps on your phone such as email, Google Sheets, Microsoft Excel, and more.