Forum Discussion
Post PatronExpression/ measures based on the give data Ask
Community ChampionYes Bakhtawar I have the Excel file open and I am looking at it, or I was just prior to responding to this post. The problem is I am not understanding things like:
1. Percentage and number of the host with the multi-listing from the total host.
OK, number of the host, so are you saying the number of distinct hosts or the rows for each host? multi=listing from the total host. I have no idea what that means. Are you saying that you want the number of rows of each host divided by the total number of rows for all hosts?
Post Patronmulti listing means if host id has duplicate records
if Host ID has duplicate records then total count of that host ie.. if 5 ID has 10 records then
host id count
5 10
6 20
and single listing means if Host ID did not repeat