https://www.growthbook.io/ logo
Join Slack
Powered by
I am new to growthbook and I am trying to perform ...
# announcements
a
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
Hi Hemant, happy to help. What is the data source?
a
data source is Mysql
f
okay. do you feel comfortable DM'ing me the full query?
or pasting it here
a
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
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
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
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
Thanks Graham
f
it's usually good practice to be owning this data yourself anyway, it lets you use it for other reports and dashboards
67 Views
Open in Slack
PreviousNext
Powered by