Charting & Data Tables
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.
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.
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:
|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|
|'||escape for text||‘Date=’|
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.