****************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-X1GEN2
Path     : C:\Users\kgnazdowsky\Documents\Find IT EZ Docs\Test Cases\PowerBI\Revenue Opportunities.pbix
****************************************************************************


Report Layout

    Page Name    "Opportunity Overview"

        Visuals

            Visualization    "0fa4715079a4d5b14dc6"
                Type    "card"

                Filters
                    Datasource Filter    SELECT
                                         	"Total Revenue"
                                         FROM
                                         	"f"."Sales"
                                         

                Fields
                    Fields    "Total Revenue"

            Visualization    "2a48b7b9c411369725ca"
                Type    "card"

                Filters
                    "Categorical" Filter    	"Sales Stage" not in ("'Finalize'")
                                            
                    Datasource Filter    SELECT
                                         	"Total Opportunity Count"
                                         FROM
                                         	"f"."Sales"
                                         	,"s"."SalesStages"
                                         WHERE
                                         	"Sales Stage" not in ("'Finalize'")
                                         

                Fields
                    Fields    "Total Opportunity Count"

            Visualization    "77960fe4d6dd7e864e6c"
                Type    "slicer"

                Filters
                    Datasource Filter    SELECT
                                         	"Product Code"
                                         FROM
                                         	"p"."Products"
                                         

                Fields
                    Fields    "Product Code"

                Properties

                    data
                        mode    "'Dropdown'"

                    general
                        selfFilterEnabled    "true"

                    header
                        show    "true"

            Visualization    "eaf58d9fd08140688010"
                Type    "treemap"

                Filters
                    "Advanced" Filter    "Total Opportunity Count"
                    "Categorical" Filter    "Region"
                    "Categorical" Filter    "Sales Stage"
                    "Categorical" Filter    "State"
                    Datasource Filter    SELECT
                                         	"Region"
                                         	,"Total Opportunity Count"
                                         	,"State"
                                         FROM
                                         	"a"."Accounts"
                                         	,"f"."Sales"
                                         ORDER BY
                                         	"Total Opportunity Count" DESC
                                         

                Fields
                    Fields    "Total Opportunity Count"

                Properties

                    categoryLabels
                        fontSize    "8D"

            Visualization    "91b894da4c7a504a0d7c"
                Type    "filledMap"

                Filters
                    Datasource Filter    SELECT
                                         	"State"
                                         	,"Total Revenue"
                                         FROM
                                         	"a"."Accounts"
                                         	,"f"."Sales"
                                         

                Fields
                    Axis    "State"

                Properties

                    mapStyles
                        mapTheme    "'grayscale'"
                        showLabels    "true"

                    categoryLabels
                        show    "false"

            Visualization    "efc42a2f1a28997b4092"
                Type    "lineStackedColumnComboChart"

                Filters
                    Datasource Filter    SELECT
                                         	"Total Revenue"
                                         	,"Total Opportunity Count"
                                         	,"Month"
                                         FROM
                                         	"f"."Sales"
                                         	,"d"."Dates"
                                         ORDER BY
                                         	"Month" ASC
                                         

                Fields
                    Axis    "Month"
                    Value    "Total Revenue"

                Properties

                    valueAxis
                        secShow    "true"
                        secShowAxisTitle    "false"
                        secFontSize    "8D"
                        titleFontSize    "8D"

            Visualization    "772b1906500006b78011"
                Type    "barChart"

                Filters
                    Datasource Filter    SELECT
                                         	"Sales Stage"
                                         	,"Total Opportunity Count"
                                         FROM
                                         	"s"."SalesStages"
                                         	,"f"."Sales"
                                         ORDER BY
                                         	"Total Opportunity Count" DESC
                                         

                Fields
                    Axis    "Sales Stage"
                    Value    "Total Opportunity Count"

                Properties

                    legend
                        showGradientLegend    "false"
                        show    "false"
                        showTitle    "false"

                    categoryAxis
                        fontSize    "8D"
                        titleFontSize    "10D"
                        concatenateLabels    "true"

                    valueAxis
                        fontSize    "8D"
                        titleFontSize    "10D"

            Visualization    "5eab58ef36b6d8e189b8"
                Type    "textbox"

                Properties

                    general
                        paragraphs    "Revenue Opportunities Report"
                                      "Opportunity overview"

            Visualization    "8a2c970418c8c8b490ba"
                Type    "barChart"

                Filters
                    Datasource Filter    SELECT
                                         	"Region"
                                         	,"Total Revenue"
                                         	,"State"
                                         FROM
                                         	"f"."Sales"
                                         	,"a"."Accounts"
                                         ORDER BY
                                         	"Total Revenue" DESC
                                         

                Fields
                    Axis    "Region"
                            "State"
                    Value    "Total Revenue"

                Properties

                    legend
                        showGradientLegend    "true"
                        show    "true"
                        showTitle    "false"

                    categoryAxis
                        concatenateLabels    "true"

            Visualization    "6a5e17d07518a05c0199"
                Type    "actionButton"

                Properties

                    icon
                        shapeType    "'rightArrow'"
                        horizontalAlignment    "'right'"
                        leftMargin    "7L"
                        rightMargin    "7L"
                        topMargin    "7L"
                        bottomMargin    "7L"

                    fill
                        show    "true"
                        transparency    "100D"

                    text
                        show    "true"
                        text    "'Select a State below to enable Drill through'"
                        horizontalAlignment    "'left'"
                        leftMargin    "0L"
                        text    "'Drill through to Detail'"
                        horizontalAlignment    "'right'"
                        rightMargin    "47L"

            Visualization    "3dbf0350b6557bb0123c"
                Type    "basicShape"

                Properties

                    general
                        shapeType    "'rectangle'"

                    line
                        weight    "0D"

            Visualization    "486075c0dea4b17203b4"
                Type    "basicShape"

                Properties

                    general
                        shapeType    "'rectangle'"

                    line
                        weight    "0D"

            Visualization    "1cd701506eae32ccc9c1"
                Type    "basicShape"

                Properties

                    general
                        shapeType    "'rectangle'"

                    line
                        weight    "0D"

            Visualization    "e786ef5a3d5c190c008d"
                Type    "basicShape"

                Properties

                    general
                        shapeType    "'rectangle'"

                    line
                        weight    "0D"

            Visualization    "f74cdd95c20076a4b388"
                Type    "basicShape"

                Properties

                    general
                        shapeType    "'rectangle'"

                    line
                        weight    "0D"

            Visualization    "2a3a4013ecf8bfed538a"
                Type    "shape"

                Properties

                    shape
                        tileShape    "'rectangle'"

                    rotation
                        shapeAngle    "0L"

                    outline
                        show    "false"

        Page Name    "Detail"

            Visuals

                Visualization    "df4f5199190e7a2291de"
                    Type    "pivotTable"

                    Filters
                        Datasource Filter    SELECT
                                             	"Opportunity Size"
                                             	,"Region"
                                             	,"Partner"
                                             	,"Total Opportunity Count"
                                             	,"Total Revenue"
                                             	,"Average Revenue"
                                             	,"Average Opportunity Days"
                                             FROM
                                             	"o"."Opportunities"
                                             	,"a"."Accounts"
                                             	,"p"."Partners"
                                             	,"f"."Sales"
                                             ORDER BY
                                             	"Total Revenue" DESC
                                             

                    Fields
                        Fields    "Total Opportunity Count"
                                  "Average Opportunity Days"
                                  "Average Revenue"
                                  "Total Revenue"

                    Properties

                        columnWidth
                            value    "161.06760709499864D"
                            value    "355.8781237542206D"
                            value    "173.04507139666575D"
                            value    "87D"
                            value    "354.25822934527844D"
                            value    "137.24011957356421D"
                            value    "118.95501770155786D"
                            value    "227.3223873331301D"
                            value    "147.30479145518174D"
                            value    "165D"
                            value    "136.2293692899064D"
                            value    "198D"

                        grid
                            outlineWeight    "3D"
                            gridVertical    "true"
                            gridVerticalWeight    "4D"
                            gridHorizontal    "true"
                            gridHorizontalWeight    "3D"
                            rowPadding    "2D"
                            textSize    "10D"

                        columnHeaders
                            fontFamily    "'''Segoe UI Bold'', wf_segoe-ui_bold, helvetica, arial, sans-serif'"
                            fontSize    "'11'"
                            wordWrap    "false"
                            autoSizeColumnWidth    "false"
                            outlineStyle    "4L"

                        rowHeaders
                            steppedLayoutIndentation    "26D"
                            wordWrap    "true"
                            showExpandCollapseButtons    "true"
                            expandCollapseButtonsSize    "'11'"
                            outlineStyle    "2L"

                        values
                            bandedRowHeaders    "true"
                            valuesOnRow    "false"
                            outlineStyle    "0L"

                        subTotals
                            perRowLevel    "false"
                            levelSubtotalEnabled    "true"
                            levelSubtotalEnabled    "true"
                            applyToHeaders    "true"
                            applyToHeaders    "true"

                        rowTotal
                            fontSize    "'15'"
                            applyToHeaders    "true"

                        columnTotal
                            fontSize    "'15'"
                            applyToHeaders    "true"

                        general
                            layout    "'Tabular'"

                Visualization    "2b022e3ea05009a0e305"
                    Type    "actionButton"

                    Properties

                        icon
                            shapeType    "'back'"
                            horizontalAlignment    "'center'"
                            leftMargin    "6L"
                            rightMargin    "6L"
                            topMargin    "6L"
                            bottomMargin    "6L"
                            show    "true"

                Visualization    "d922170a10104e3e8606"
                    Type    "textbox"

                    Properties

                        general
                            paragraphs    "Opportunity Analysis Report"
                                          "Opportunity detail"

            Page Name    "Tooltip"

                Visuals

                    Visualization    "f2743f4e08200c0ed75b"
                        Type    "donutChart"

                        Fields
                            Axis    "Account.Segment"
                            Value    "Fact.Revenue"

                        Properties

                            legend
                                show    "false"
                                position    "'Right'"
                                showTitle    "false"
                                fontSize    "'9'"

                            labels
                                show    "true"
                                fontFamily    "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
                                labelStyle    "'Both'"

                    Visualization    "4d97de1a92eb689d8025"
                        Type    "card"

                        Fields
                            Fields    "Fact.Revenue"

                        Properties

                            labels
                                fontSize    "16D"
                                labelPrecision    "1L"
                                preserveWhitespace    "true"

                            wordWrap
                                show    "true"

                            categoryLabels
                                show    "false"