Skip to main content

Hi,

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?

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.

Reply


Terms & Conditions