#announcements
Title
a
average-city-57765
01/19/2022, 6:02 AMI am new to growthbook and I am trying to perform the AB testing , so while adding matrix I am getting this error . I have added the MySQL database.
f
fresh-football-47124
01/19/2022, 6:03 AM
Hi Hemant, happy to help. What is the data source?
a
average-city-57765
01/19/2022, 6:04 AMdata source is Mysql
f
fresh-football-47124
01/19/2022, 6:04 AM
okay. do you feel comfortable DM'ing me the full query?
or pasting it here
a
average-city-57765
01/19/2022, 6:06 AMSELECT
user_id as user_id,
anonymous_id as anonymous_id,
1 as value,
received_at as timestamp
FROM
downloads
may be i am doing some mistake but i not able to tack that particular mistake.
track
f
fresh-football-47124
01/19/2022, 6:08 AM
heh, ya, it's a bit tricky. - what is happening is that to generate the time series graph for that metrics page, we are using the 'page views' query
which is set up on the 'data sources' page
can you double check if that query is working?
a
average-city-57765
01/19/2022, 6:10 AMok let me check
my friend is checking for the query. Apart from that, I have gone through the matrix documentation I found the example queries, in these queries tables like registration, downloads are mentioned so these tables are generated by themselves or the user has to create the table like that.
f
fresh-football-47124
01/19/2022, 6:31 AM
for any metric, you need to include some kind of user_id, a timestamp, and a value... these table are the user's responsibility, GrowthBook doesn't create any tables
a
average-city-57765
01/19/2022, 6:32 AMThanks Graham
f
fresh-football-47124
01/19/2022, 6:32 AM
it's usually good practice to be owning this data yourself anyway, it lets you use it for other reports and dashboards