https://www.growthbook.io/ logo
a

average-city-57765

01/19/2022, 6:02 AM
I 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 AM
data 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 AM
SELECT 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 AM
ok 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 AM
Thanks 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