For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Data Source Link

Available Access Formats


Sources and Modeling

Row Color Derived Column
Row Color Column Not Used by Open Data Bits

Logical Model

Calculated Columns & Calculations

Name DAX Expression Type
Connecticut Fiscal Key =DATE(([fiscal_year]-1),”07″,”01″) Calculated Column
Zip Code 5 Digit Key =LEFT([zip_code],5) Calculated Column
Full Address =CONCATENATE([address],CONCATENATE(“, “,CONCATENATE([municipality],CONCATENATE(“, “,CONCATENATE([state],CONCATENATE(“, “,[zip_code])))))) Calculated Column
Count Count:=COUNTROWS(‘Table Name’) Calculation
Grant Amt Total Grant Amt Total:=SUM([grant_amount]) Calculation
Loan Amt Total Loan Amt Total:=SUM([loan_amount]) Calculation
Total Assistance Total Assistance:=SUM([total_assistance]) Calculation
Total Project Cost Total Project Cost:=SUM([total_project_cost]) Calculation
Amount Leveraged Total Amount Leveraged Total:=SUM([amount_leveraged]) Calculation
Grant Amt % Grant Amt %:=DIVIDE([Grant Amt Total],[Total Project Cost]) Calculation
Loan Amt % Loan Amt %:=DIVIDE([Loan Amt Total],[Total Project Cost]) Calculation
Total Assistance % Total Assistance %:=DIVIDE([Total Assistance],[Total Project Cost]) Calculation
Total Project Cost Max Total Project Cost Max:=MAX([total_project_cost]) Calculation
Grant Amt Max Grant Amt Max:=MAX([grant_amount]) Calculation
Loan Amt Max Loan Amt Max:=MAX([loan_amount]) Calculation

Examples for Reference

Open Data Bits – Connecticut Department of Economic and Community Development Portfolio Open Data Feature