I have created a chart with several dimensions and expressions. I am attempting to add in a relatively simple expression of =CURRENTPRICE however, when I apply the expression, not data is displayed.
When I add in an aggregation method such as MIN, MAX, SUM, etc. I get data.
Any ideas on where I am going wrong would be helpful. I have attached my data model and below are the dimensions I am using as well as a small sample of what the table looks like
Pacing: select TO_CHAR(po.created_date, 'MM/DD/YYYY') AS ScottsDate, es.last_updated_date, e.event_code AS EVENTCODE, e.event_date, e.price_structure_id AS PRICESTRUCTUREID, a.agency_code, bt.buyer_type_code, bt.description AS buyer_type_desc, c.channel_code, c.description AS channel_desc, ps.price_scale_code AS PRICESCALECDE, ps.description AS PRICESCALEDESC, es.price, sec.section_code, s.row_, bt.description AS BuyerTypeDesc, s.seat_number, COUNT(1) AS QTY
from agency a, buyer_type bt, channel c, event e, event_category ec, event_seat es, order_line_item oli, patron_order po, price_scale ps, seat s, section sec
where oli.order_id = po.order_id and oli.usage_event_id = e.event_id and es.event_id = e.event_id and es.order_id = po.order_id and es.order_line_item_id = oli.order_line_item_id and po.created_by_agency_id = a.agency_id and a.channel_id = c.channel_id and e.event_category_id = ec.event_category_id and sec.section_id = es.section_id and s.seat_id = es.seat_id and es.buyer_type_id = bt.buyer_type_id and ps.price_scale_id = es.price_scale_id
and oli.market_type_code = 'P' and oli.transaction_type_code in ( 'SA', 'ES', 'CS' ) and c.channel_code in ( 'BOXOFF', 'INTERNET', 'PHONE' ) and ec.event_category_code = 'SPORT' and e.event_id IN ('5636', '5637', '5638', '5639', '5640', '5641', '5642', '5644', '5645', '5646', '5647', '5648', '5649', '5650', '5651', '5652', '5653', '5654', '5655', '5656', '5657', '5658', '5659', '5660', '5661', '5662', '5663', '5664', '5665', '5666', '5667', '5668', '5669', '5670', '5671', '5672', '5673', '5674', '5675', '5769')
GROUP BY po.created_date, es.last_updated_date, e.event_code, e.event_date, e.price_structure_id, a.agency_code, bt.buyer_type_code, bt.description, c.channel_code, c.description, ps.price_scale_code, ps.description, es.price, sec.section_code, s.row_, bt.description, s.seat_number;
CurrentPrices: select E.EVENT_CODE AS EVENTCODE, PS.PRICE_SCALE_CODE AS PPPRICESCALECDE, PS.DESCRIPTION AS PPPRICESCALEDESC, PP.PRICE AS CURRENTPRICE
FROM PRICE_POINT PP, PRICE_SCALE PS, EVENT E
WHERE PP.PRICE_SCALE_ID = PS.PRICE_SCALE_ID AND PP.PRICE_STRUCTURE_ID = E.PRICE_STRUCTURE_ID AND PP.BUYER_TYPE_ID = '1' AND PP.PRICE_STRUCTURE_ID IN ('11786', '11787', '11788', '11789', '11790', '11791', '11792', '11794', '11795', '11796', '11797', '11798', '11799', '11800', '11801', '11802', '11803', '11804', '11805', '11806', '11807', '11808', '11809', '11810', '11811', '11812', '11813', '11814', '11815', '11816', '11817', '11818', '11819', '11820', '11821', '11822', '11823', '11824', '11825', '11844') AND PS.PRICE_SCALE_CODE IN ('CLUB', 'CLUBEN', '100PRF', '100LV2', '100LV3', '100LV4', '300LV1', '300LV2', '300LV3', '300LV4', '300LV5', '300LV6')
GROUP BY E.EVENT_CODE, PS.PRICE_SCALE_CODE, PS.DESCRIPTION, PP.PRICE
ORDER BY EVENT_CODE;
SCHEDULE:
LOAD "GAME ID", "Home Game", "WEEKDAY", "MONTH", "DAY", "Game Date", "YEAR", "TIME", "Event ID", "Event Code" AS EVENTCODE, SUBJECT, Opponent, "Game Description", LOCATION, CITY, ST, "TYPE", "VAR. PRICE" AS TIER, "VAR. Price Numeric" FROM [data source]
Manifest:
LOAD "Price Scale Code" AS PRICESCALECODE, "Price Scale Description" AS PRICESCALEDESC, "Price Scale ID" AS priceSCALEID, SECTION_GROUP_DESCRIPTION AS sectionGROUP, "Section" AS maniSECTION, "Row" AS maniROW, "Seat Number" AS maniSEAT, "Section Capacity" AS secCAP, "Price Level Capacity" AS plttlCAP, "After Kills PL Capacity" AS PLCAP, "Section Delimit" AS secDELIMIT, "Section Overall" AS secOVERALL FROM [data source];
