Distribution of values created from CountOver field

Question & Answer
, , , ,
1

I have a table of Venue Visits, each row with a corresponding User Id.

Sandbox Screenshot

I would like to create a histogram of number of user-visits. The resulting values should be as follows:

1 visit: 2
2 visits: 2
3 visits: 1

I can use CountOver, paired with User Id to capture the number of visits each user has made -

countOver({User_ID}, [User_ID], PRE_AGG)

How can I create a distribution of these numbers, capturing the number of users who have made n visits?

2

Hi @CanoeData,

If you create a field in SQL to calculate the number of visits each user has made you can then simply add that field to a histogram to get the number of users who have made n visits. This is a workaround to the Quicksight requirement of including the field used in your calculation in the visual which is not possible in the histogram in this use case.

Another option is to do the above but using a bar chart and the User_ID field which will allow you to see the specific value in the x-axis instead of the range of values you will have in the x-axis if you use a histogram.

Here is some additional information on Histograms in QuickSight.