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

http://data.gc.ca/data/en/dataset/f79b3ec4-5b50-4ec1-894d-e9855148e55d

Available Access Formats

CSV

Sources and Modeling

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

Calculated Columns & Calculations

Name DAX Expression Type
Survey Count Survey Count:=COUNTROWS(‘Survey’) Calculation
Diabetes Very or Somewhat Serious % Diabetes Very or Somewhat Serious %:=DIVIDE(CALCULATE([Survey Count],OR(Survey[q3cx]=”Very Serious”,Survey[q3cx]=”Somewhat Serious”)),[Survey Count]) Calculation
HIV-AIDS Very or Somewhat Serious % HIV-AIDS Very or Somewhat Serious %:=DIVIDE(CALCULATE([Survey Count],OR(Survey[q3fx]=”Very Serious”,Survey[q3fx]=”Somewhat Serious”)),[Survey Count]) Calculation

Examples for Reference

Open Data Bits – Canada 2012 HIV/AIDS Attitudinal Tracking Survey Open Data