def test_series_across_multiple_groupings_and_metrics(self): matrix = MatrixParser(self.build_mock_report('matrix_complex')) series = matrix.series_across(['New Customer', 'Express Logistics and Transport'], col_groups='Q1-2014', value_position=1) self.assertEquals(series["March 2014"], 220000)
def test_get_col_total_col_not_found_user_set(self): report = MatrixParser(self.build_mock_report('matrix_complex')) col_total = report.get_col_total( 'Q1-2016', default='No data available for period selected.') self.assertEquals(col_total, 'No data available for period selected.')
def test_series_for_col_with_row_grouping(self): matrix = MatrixParser(self.build_mock_report('matrix_basic')) series = matrix.series_down('December 2013', row_groups='Existing Customer - Upgrade') self.assertEquals(series["University of Arizona"], 90000) self.assertEquals(series["Edge Communications"], 60000)
def test_series_across_multiple_groupings_and_metrics(self): matrix = MatrixParser(self.build_mock_report('matrix_complex')) series = matrix.series_across( ['New Customer', 'Express Logistics and Transport'], col_groups='Q1-2014', value_position=1) self.assertEquals(series["March 2014"], 220000)
def test_series_down_multiple_groupings_and_metrics(self): matrix = MatrixParser(self.build_mock_report('matrix_complex')) series_record_count = matrix.series_down(['Q4-2013', 'October 2013'], row_groups='Existing Customer - Upgrade', value_position=2) series_annual_revenue = matrix.series_down(['Q4-2013', 'October 2013'], row_groups='Existing Customer - Upgrade', value_position=0) self.assertEquals(series_record_count["GenePoint"], 1) self.assertEquals(series_annual_revenue["GenePoint"], 30000000)
def test_series_down_multiple_groupings_and_metrics(self): matrix = MatrixParser(self.build_mock_report('matrix_complex')) series_record_count = matrix.series_down( ['Q4-2013', 'October 2013'], row_groups='Existing Customer - Upgrade', value_position=2) series_annual_revenue = matrix.series_down( ['Q4-2013', 'October 2013'], row_groups='Existing Customer - Upgrade', value_position=0) self.assertEquals(series_record_count["GenePoint"], 1) self.assertEquals(series_annual_revenue["GenePoint"], 30000000)
def test_get_row_total_row_found(self): report = MatrixParser(self.build_mock_report('matrix_basic')) row_total = report.get_row_total('New Customer') self.assertEquals(row_total, 1790000)
def test_series_for_col(self): matrix = MatrixParser(self.build_mock_report('matrix_basic')) series = matrix.series_down('March 2014') self.assertEquals(series["New Customer"], 430000)
def test_get_col_total_col_not_found_default(self): report = MatrixParser(self.build_mock_report('matrix_basic')) col_total = report.get_col_total('January 2015') self.assertIsNone(col_total)
def test_get_col_total_nested_top_level(self): report = MatrixParser(self.build_mock_report('matrix_complex')) col_total = report.get_col_total('Q3-2013') self.assertEquals(col_total, 5600000000)
def test_get_col_total_nested_level_down(self): report = MatrixParser(self.build_mock_report("matrix_complex")) col_total = report.get_col_total('December 2013') self.assertAlmostEqual(col_total, 5739000000)
def test_series_for_row(self): matrix = MatrixParser(self.build_mock_report('matrix_basic')) series = matrix.series_across('New Customer') self.assertEquals(series["May 2013"], 75000)
def test_series_down_with_multiple_col_groupings(self): matrix = MatrixParser(self.build_mock_report('matrix_complex')) series = matrix.series_down(['Q4-2013', 'October 2013']) self.assertEquals(series["New Customer"], 0)
def test_get_col_total_col_not_found_user_set(self): report = MatrixParser(self.build_mock_report('matrix_complex')) col_total = report.get_col_total('Q1-2016', default='No data available for period selected.') self.assertEquals(col_total, 'No data available for period selected.')
def test_get_col_total_col_found(self): report = MatrixParser(self.build_mock_report('matrix_basic')) col_total = report.get_col_total('September 2013') self.assertEquals(col_total, 120000)
def test_series_across_multiple_row_groupings(self): matrix = MatrixParser(self.build_mock_report('matrix_basic')) series = matrix.series_across(["New Customer", "GenePoint"]) self.assertEquals(series["December 2013"], 85000)