Multiple columns of the table to x-axis of the chart

Topic Labels: Custom Extensions
1703 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a table that I put numbers to all the columns daily.
And I have a problem making a chart out of this.

This table represents the visitor numbers of my website daily and I want to visualize the ratio of the visitor’s age group in total.

columns are
/Age 13-24 / Age 25-34 / Age 35-44 / Age 45-54 / Age 55-64 …

Primary row is the date.

I cannot figure out how I can make x-axis in chart same as my columns and show the sum of the everyday counts as y-axis?

1 Reply 1

Hi @Jessica_Shin,

The easiest way to solve your problem is to convert the structure of your data slightly, such that each data point is a single record, rather than having a record per day with multiple data points.

Here’s what you’d need to do to make that happen:

  • Create a single-select field where the options represent all the age groups you are tracking (ie, the options have the same names as the fields you currently use to track age ranges)
  • Supposing you have 6 age ranges you are tracking, every day you will make 6 records corresponding to the current date, instead of one — one record for each age range, selected by single-select, for the current day.

With that setup, you’ll be able to set up a graph where you can see your total visits per day aggregated by the age-ranges that make up the total.