Didn't this question get answered once already? check users, How to create month on month increment, etc. It appears you have several threads related to this same question--yet, many of those questions are marked as "answered" so I'm a bit confused by what you're looking for.
The user you pointed out with 3 bookingIDs would be considered a "repeat user" within that month--is that what you want to identify, or are you hoping to count new users by month--meaning, they have a bookingID in one month, and later have another?
Sorry if I am making any confusion with multiple posts
All these posts are different things i am trying on
Yes I am trying to show any users who is having booking id more than one
like the example provided 3 bookingIDs would be considered a "repeat user" within that month
So this way any user having bookingIDs more than 1 is a repeat user and would like to see them monthly
We can either use countd(bookingid) or count(emailid) in the filter start from 2 which gives us list of repeat users
The problem is with line chart It is so clumsy when taking emailid in detail level
So can we show the line chart like the snapshot provided Is it possible
I'm not clear on your end goal. What are you hoping to illustrate in the line chart?
When you say "repeat users by month", I think of users who had a bookingID in one month, and then later had another bookingID in another month. But by your definition, you are identifying users within each month who made more than one purchase. That's a different type of problem.
So which are you looking for? Repeat users by month, or users that made more than one purchase in a month? And how do you want this data displayed? You say you want a line chart, but what should the line chart represent? Counts of "users with more than one purchase in the month"? Or do you want something else?
I think that once you clarify your goal, you'll be far more likely to get accurate help. See also:
I'm also not sure how well a line chart will represent this data--you only have subsequent month entries for a few emailIDs, so I'm not clear on what you're hoping to achieve in a line chart with so little data.
From my understanding I see that you are trying to get the user based on the number of booking greater than 2 and take the count of the email id as one , as per the logic I see there are 7321 repeated users in the dataset you have provided in the sample. The aggregation level doesnt allow you to see the data in a line graph. I assume this logic should be handled in the ETL .
As Mathew Suggested please be specific with what you wanted to achieve, it will be really hard to understand your usecase and help.
Sorry for the delay in response
Thanks for your inputs I would opt for bar chart
however I am facing issue while displaying results I would like to see total number of emailid's value on top of each bar as i am trying this for month over month
Tried using reference lines,size but I am not able to achieve it its showing just the sum(bookingid)