Table formatting for Bar, Line, and Area charts

Bar, Area, and Line charts all accept a similar table format. Here's a brief explanation on the types of table formats these charts accept, along with chart examples.

Two columns

One measure grouped by one dimension

  • First column maps to x-axis
  • Second column maps to y-axis

Sample table

Week of Payment Date Total sum of Amount
2015-W014840
2015-W025270
2015-W033190
2015-W047020

 

One measure grouped by two dimensions

  • Add Pivot step, which allows the second column's values to each become a new column. View an example of a Pivot here.
  • First column maps to x-axis
  • After the pivot, subsequent columns map to the y-axis and are grouped and labeled by their column name

Sample table (before Pivot step)

Week of Payment Date Payment Type Total sum of Amount
2015-W01Invoice4840
2015-W01Credit Card5270
2015-W02Invoice3190
2015-W02Credit Card7020

Sample table (after Pivot step)

Week of Payment Date Invoice Credit Card
2015-W0148405270
2015-W0131907020

 

Multiple measures grouped by one dimension

  • First column maps to x-axis
  • Subsequent columns are mapped to the y-axis, and are grouped and labeled by their column name
  • Tooltip displays second through last column on hover.

Sample table

Week of Payment Date Count of Payments Total sum of Amount
2015-W012034840
2015-W021155270
2015-W032913190
2015-W041857020