Please enable JavaScript.
Coggle requires JavaScript to display documents.
Overages (Order of Operations (Context Filters (Activation Type, Month…
Overages
Order of Operations
Data Source Filters
prod.mvno_bi_accounts
prod.mvno_bi_account_lines
line_status = 'AC'
prod.mvno_daily_usage_agg_bu
prod.mvno_bill_cycle_date
prod.MVNO_rate_plan_switchers
Context Filters
Activation Type
Month Plan
BCDMONTHEquals
AccountStatus=AC
account_type_flag:PROD
change_type
line_status: AC
Dimension Filters
T|F Buckets check BTG: True
Switchers
change_type - exclude Downgrade
Include Exclude LOD
Switchers Drill Down
Total Mobile Usage -
{ EXCLUDE [retail_plan_id]:sum([Domestic Usage (GB)])}
Domestic Usage (GB)
{ EXCLUDE [Bill Cycle Usage Day] : Sum([Domestic Usage])}
Domestic Usage - [art_data_usage_dom]/1024/1024
Measure Filter
Totals
Worksheets
Switchers
Distribution
Threshhold Line Counts
Threshhold Buckets
Drill Down Encrypted and Unencrypted
BTG
Distributtion
Threshhold Buckets
Drill Down Encrypted and Unencrypted
Threshold Line Counts
UNL
Distribution of Unlimited Usage
Threshold Line Counts
Threshold Buckets
Drill Down Encrypted and Unencrypted
Columns
buckets
BTG
BTG OTC
UNL
UNL OTC
Switcher
Line Count
Rows
Histogram
[Avg Cell Usage per Line]
{FIXED [Activation Number Encrypted],[bcdmonth]
: (sum([art_data_usage_dom]+[art_data_usage_int]+[art_data_usage_int_roam])/1024/1024)}
Switcher Drill Down
Activation Number
Total Mobile Usage
Bill Cycle Day
Switch_Date
Domestic Usage
Marks
DATA OVERAGES
:
test