<p>I am brand new to Brit and am attempting to build out my first report. Its pretty simple however the query that generates the data will not load in the dataset wizard. below is the query</p>
<p> </p>
<p> </p>
<div>select city,active_count,green_count,yellow_count,red_count,total_count,</div>
<div>case when city != 'other'</div>
<div> <span> </span>then (active_count/green_count) </div>
<div>end market_take,</div>
<div>case when city != 'other'</div>
<div> <span> </span>then (green_count/total_count)</div>
<div>end green_take,</div>
<div>case when city != 'other'</div>
<div> <span> </span>then (yellow_count/total_count)</div>
<div>end yellow_take,</div>
<div>case when city != 'other'</div>
<div>then (red_count/total_count)</div>
<div>end red_take</div>
<div>from</div>
<div>(select </div>
<div> <span> </span>city_group city,</div>
<div> <span> </span>count(case when group_color = 'GREEN' and city_group != 'other'</div>
<div> <span> </span>then 1</div>
<div> <span> </span>end)green_count,</div>
<div> <span> </span>count(case when group_color = 'YELLOW' and city_group != 'other'</div>
<div> <span> </span>then 1</div>
<div> <span> </span>end)yellow_count,</div>
<div> <span> </span>count(case when group_color = 'RED' and city_group != 'other'</div>
<div> <span> </span>then 1</div>
<div> <span> </span>end)red_count,</div>
<div> <span> </span>count(address_id) Total_count,</div>
<div> <span> </span>count(case when au_address_status = 'ACTIVE'</div>
<div> <span> </span>then 1</div>
<div> <span> </span>end) Active_count </div>
<div>from osp.om_address_lookup_more_info</div>
<div>group by city_group)</div>
<div> </div>
<div>Not sure why this will not load. Are inline views not supported? (the inner query would load but not the entire query).</div>
<div> </div>
<div>Also the query does run in sql developer and sql++ without issue and in my development code.</div>
