Beast Mode Calculations with logics

user0010266
user0010266
in Archive

Hi,

I have a dataset like below where i want following calculations - 

1. If Date, Business Name and Town, Country, Region etc is same - It counts Page rows and returns 3 or 2 or 1

2. If above fields are same, it subtracts Page Viewed Time Date rows to find time spent on each page, if starting page then it can remain 2 sec as a constant

VisitDateTimeBusinessTownCountryTelephoneWebsitePagePageViewedDateTimeIndustryRegion
Sep  6 2017 12:11AMTopcon Positioning Systems IncLivermore (CA)United States(800) 443 4567www.topconcareers.comhttp://www.wns.com/6/9/2017 0:11MaritimeEurope
Sep  6 2017 12:11AMTopcon Positioning Systems IncLivermore (CA)United States(800) 443 4567www.topconcareers.comhttp://www.wns.com/solutions6/9/2017 0:11MaritimeAsia Pacific
Sep  6 2017 12:11AMTopcon Positioning Systems IncLivermore (CA)United States(800) 443 4567www.topconcareers.comhttp://www.wns.com/solutions/technology6/9/2017 0:11MaritimeAsia Pacific
Sep  6 2017  1:05AMMcKinsey & CompanyNew York (NY)United States(212) 446 7000www.mckinsey.comhttp://www.wns.com/about-wns/global-presence6/9/2017 1:05Market ResearchAsia Pacific
Sep  6 2017  1:27AMJackson County Economic Development Foundation IncPascagoula (MS)United States(800) 362 0103www.jcedf.orghttp://www.wns.com/6/9/2017 1:27Commercial Real EstateAsia Pacific
Sep  6 2017  1:27AMJackson County Economic Development Foundation IncPascagoula (MS)United States(800) 362 0103www.jcedf.orghttp://www.wns.com/6/9/2017 1:28Commercial Real EstateAsia Pacific
Sep  6 2017  1:35AMPhinney BischoffSeattle (WA)United States(206) 322 3484www.phinneybischoff.comhttp://www.wns.com/insights/blogs/blogdetail?343=reading6/9/2017 1:35Medical PracticeNorth America
Sep  6 2017  2:27AMColeman UniversitySan Diego (CA)United States(858) 499 0202www.coleman.eduhttp://www.wns.com/solutions/functional-solutions/analytics/operational-analytics6/9/2017 2:27EngineeringNorth America

Comments

Categories