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_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_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_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_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_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_series_for_col(self):
        matrix = MatrixParser(self.build_mock_report('matrix_basic'))

        series = matrix.series_down('March 2014')

        self.assertEquals(series["New Customer"], 430000)