This message was deleted.

Hi Nitin, I am a Data Scientist at GrowthBook. For your metric, are you using

1

as the value column? This is ideal for counting rows (please see attached screenshot from the

Metric

page on GrowthBook's UI). Thanks, Luke

@steep-dog-1694 let me check this and get back to you,

Please click the

Edit

button next to

Query Settings

Is the highlighted field you are talking about?

No - it is above the Query

Here's the screencast , yeah it's a count metric

Thanks - I'm not sure if there is supposed to be audio, but I can't hear it. What version of GrowthBook are you using? We have updated our metric fields a bit. However, based upon your large sums and sums of squares, it looks like you may be summing the

user_id

values, rather than their counts? In your query, ,can you please check that when you sum

value = 1

?

By growthbook version, you mean the sdk version or growthbook UI?

UI

Where can i see the UI version?

yes

Is there a way to resolve this issue with the current free version?

Given how large your sums and sums of squares are, it looks like you are summing the values for the

id

, rather than counting the number of ids. I would try changing your sql:

value_param.value.int_value as value

to

1 as value

@steep-dog-1694 I need one more help in this. Do you know how we can only get the count of users and not

main_sum

and

main_sum_squares

in the dashboard.

SELECT
  m.variation AS variation,
  m.dimension AS dimension,
  COUNT(*) AS users,
  SUM(COALESCE(m.value, 0)) AS main_sum,
  SUM(POWER(COALESCE(m.value, 0), 2)) AS main_sum_squares

how can this query be updated to get only

COUNT(*) AS users

and not others. As shown the highlighted values in the below screenshot. i need only COUNT of users but the combined query gives everything.

Hi Nitin, Are you hoping to run a query that returns only user counts, or are you hoping that the

main_sum

and

main_sum_squares

results aren't in the dashboard? If the former, please run this:

SELECT
  m.variation AS variation,
  m.dimension AS dimension,
  COUNT(*) AS users

If the latter, we cannot suppress results from showing in the dashboard. Hope this helps, Luke

I am hoping to run a query that returns only user counts,

I'm sorry, I deleted the extra two lines in the my message above, please try the query now

How can i run the query in the GrowthBook? That entire query is auto generated and I don't see any option to edit.

I'm sorry, you can't run the query standalone in GrowthBook.

So we will always receive

main_sum

and

main_sum_squares

as part of the result, and it cannot not be modified as it is required to generate the variants' dashboard, right?

correct

Any workaround to get only Count of the users?

not that I know of.

I thought there should be some way to get only count of the users.

User counts can be found on the health tab.