In this blog post, sharing guidewire claims how many claims got created per city and per state basics Databricks it is available here : Claim happened from most US State Insights data analytics Template V1.0 - Databricks SQL Sample code select AX.CITY, count( AX.CLAIM_NUMBER) as TOTAL_CLAIMS_PER_CITY from ( select distinct C.CLAIMNUMBER as CLAIM_NUMBER, ST. NAME as STATE, ADDR.CITY from guidewire_raw_db.cc_claim C left join guidewire_raw_db.cc_contact CONT on C.INSUREDDENORMID = CONT. ID left join guidewire_raw_db.cc_address ADDR on CONT.PRIMARYADDRESSID = ADDR. ID left join guidewire_raw_db.cctl_state ST on ADDR.STATE = ST. ID ) AX group by AX.CITY order by 2 desc From these SQL Query Resultsets Feed into Tableau Public Edition This Tableau Public view Available here https://public.tableau.com/views/Guidewire_Insurance_Claims_Insights_one/InsuranceClaimsPerCity?:language=en-US&:sid=&:redirect=auth&:display_count=n&...