Plotting data against time
GravityCharts allows you to plot data against time. In other words, you can have the date on the X axis and a numerical value on the Y axis. In this article, we will show you how to plot data against time and explain how this functionality works.
Example: Revenue / time
Here's an example where we are plotting revenue in USD (on the Y axis) against the date (on the X axis).
How to create a timeline chart
When you create a new chart in GravityCharts, you will see the option to "Show on Timeline" under "Data Type" in the "Chart Data" settings panel. After you select this option, you will need to specify the date field, timeline type, and data field.
Here's an overview of the different options in a little more detail:
- Data type: Plot data by field (default) or on a timeline.
- Date field: Select the date field that should be used for the X axis. You can choose between the entry date or a specific "Date" field in your form.
- Timeline type: Choose between "sum values", "average values" or "entry count". (Only relevant for Number fields).
- Data field: If "timeline type" is set to "sum values" or "average values", you will need to specify a form field here with numerical data (this is the field you want to plot on the Y axis). If you selected "entry count" as your timeline type, there is no need to select a data field here, as GravityCharts will simply retrieve the number of entries received per date and plot that.
When you open the "Axis" drop down, you will see the option to adjust the timeline scale and labels. You can set the scale to either "Day", "Week", "Month", "Quarter" or "Year".
By default, the timeline labels option is set to "Automatic", meaning that all dates, irrespective of whether they have corresponding entries, will be displayed on the X axis, for the period of time between the first and last entry. If you set this option to "Data points only", then only the dates with entries will show up as labels on the X axis.
The chart preview will update in real-time as you make changes, so feel free to experiment with different options and configurations to get the graph you want.
Limitations for plotting data against time
When plotting data against time, you have the option to plot the entry count by date, or the sum or average of a specific field by date. You cannot yet plot multiple datasets on a single chart.
Plotting data against time is supported for Number and Pricing fields, as well as select fields (Radio Buttons, Checkboxes, and Drop Downs), provided they include a numerical "value" attribute.