Getting started

Important
Starting with v16.2.0.x, if you refer to Syncfusion assemblies from trial setup or from the NuGet feed, include a license key in your projects. Refer to this link to learn about registering Syncfusion license key in your ASP.NET Core application to use our components.

Refer the Getting Started page of the introduction part to know more about the basic system requirements and the steps to configure the Syncfusion components in an ASP.NET Core application.

Ensure whether all the necessary dependency packages are included within the bower.json file as mentioned here, so that the required scripts and CSS to render the pivot gauge control will be installed and loaded into the mentioned location (wwwroot -> lib) within your project.

Also, check whether the assembly dependency package Syncfusion.EJ.Pivot is added within the project.json file.

Now, refer to the necessary scripts and CSS files in your _Layout.cshtml page from the wwwroot -> lib -> syncfusion-javascript folder.

  • cshtml
  • <html>
    <head>
        <environment names="Development">
            <link rel="stylesheet" href="~/lib/bootstrap/dist/css/bootstrap.css" />
            <link rel="stylesheet" href="~/css/site.css" />
            <link href="~/lib/syncfusion-javascript/Content/ej/web/default-theme/ej.web.all.min.css" rel="stylesheet" />
            <link href="~/lib/syncfusion-javascript/Content/ej/web/responsive-css/ej.responsive.css" rel="stylesheet" />
        </environment>
    </head>
    <body>
    
        <environment names="Development">
            <script src="~/lib/jquery/dist/jquery.js"></script>
            <script src="~/lib/bootstrap/dist/js/bootstrap.js"></script>
            <script src="~/js/site.js" asp-append-version="true"></script>
            <script src="~/lib/syncfusion-javascript/Scripts/jsrender.min.js"></script>
            <script src="~/lib/syncfusion-javascript/Scripts/ej/web/ej.web.all.min.js"></script>
        </environment>
    
    </body>
    </html>

    It is necessary to define the following namespace within the _viewImports.cshtml page to make use of the pivot gauge control with the tag helper support.

  • cshtml
  • @using Syncfusion.JavaScript
    @addTagHelper "*, Syncfusion.EJ"
    @addTagHelper "*, Syncfusion.EJ.Pivot"

    NOTE

    Script manager should be defined at the bottom of the _Layout.cshtml page.

    Relational

    This section covers the information required to populate a simple pivot gauge with the relational data source.

    Initialize pivot gauge

    Before initializing the pivot gauge, empty the contents of Index.cshtml file under Views > Home folder and add the following codes:

  • cshtml
  • <ej-pivot-gauge id="PivotGauge1"></ej-pivot-gauge>

    Populate pivot gauge with data

    This section illustrates how to populate the pivot gauge control by using a sample JSON data as shown below:

  • cshtml
  • <ej-pivot-gauge id="PivotGauge1" load="onload"></ej-pivot-gauge>
    
    <script type="text/javascript">
    function onload(args) {
        args.model.dataSource.data = [
                        { Amount: 100, Country: "Canada", Date: "FY 2005", Product: "Bike", Quantity: 2, State: "Alberta" },
                        { Amount: 200, Country: "Canada", Date: "FY 2006", Product: "Van", Quantity: 3, State: "British Columbia" },
                        { Amount: 300, Country: "Canada", Date: "FY 2007", Product: "Car", Quantity: 4, State: "Brunswick" },
                        { Amount: 150, Country: "Canada", Date: "FY 2008", Product: "Bike", Quantity: 3, State: "Manitoba" },
                        { Amount: 200, Country: "Canada", Date: "FY 2006", Product: "Car", Quantity: 4, State: "Ontario" },
                        { Amount: 100, Country: "Canada", Date: "FY 2007", Product: "Van", Quantity: 1, State: "Quebec" },
                        { Amount: 200, Country: "France", Date: "FY 2005", Product: "Bike", Quantity: 2, State: "Charente-Maritime" },
                        { Amount: 250, Country: "France", Date: "FY 2006", Product: "Van", Quantity: 4, State: "Essonne" },
                        { Amount: 300, Country: "France", Date: "FY 2007", Product: "Car", Quantity: 3, State: "Garonne (Haute)" },
                        { Amount: 150, Country: "France", Date: "FY 2008", Product: "Van", Quantity: 2, State: "Gers" },
                        { Amount: 200, Country: "Germany", Date: "FY 2006", Product: "Van", Quantity: 3, State: "Bayern" },
                        { Amount: 250, Country: "Germany", Date: "FY 2007", Product: "Car", Quantity: 3, State: "Brandenburg" },
                        { Amount: 150, Country: "Germany", Date: "FY 2008", Product: "Car", Quantity: 4, State: "Hamburg" },
                        { Amount: 200, Country: "Germany", Date: "FY 2008", Product: "Bike", Quantity: 4, State: "Hessen" },
                        { Amount: 150, Country: "Germany", Date: "FY 2007", Product: "Van", Quantity: 3, State: "Nordrhein-Westfalen" },
                        { Amount: 100, Country: "Germany", Date: "FY 2005", Product: "Bike", Quantity: 2, State: "Saarland" },
                        { Amount: 150, Country: "United Kingdom", Date: "FY 2008", Product: "Bike", Quantity: 5, State: "England" },
                        { Amount: 250, Country: "United States", Date: "FY 2007", Product: "Car", Quantity: 4, State: "Alabama" },
                        { Amount: 200, Country: "United States", Date: "FY 2005", Product: "Van", Quantity: 4, State: "California" },
                        { Amount: 100, Country: "United States", Date: "FY 2006", Product: "Bike", Quantity: 2, State: "Colorado" },
                        { Amount: 150, Country: "United States", Date: "FY 2008", Product: "Car", Quantity: 3, State: "New Mexico" },
                        { Amount: 200, Country: "United States", Date: "FY 2005", Product: "Bike", Quantity: 4, State: "New York" },
                        { Amount: 250, Country: "United States", Date: "FY 2008", Product: "Car", Quantity: 3, State: "North Carolina" },
                        { Amount: 300, Country: "United States", Date: "FY 2007", Product: "Van", Quantity: 4, State: "South Carolina" }
        ];
    }
    </script>

    The JSON data is set to the “data” property present in the “e-data-source” object. The “e-data-source” object allows you to set both datasource and fields that should be displayed in the row, column, value, and filter section of the pivot gauge control.

  • cshtml
  • <ej-pivot-gauge id="PivotGauge1" background-color="transparent" load="onload">
        <e-data-source>
            <e-pivot-rows>
                <e-row-field field-name="Country" field-caption="Country"></e-row-field>
            </e-pivot-rows>
            <e-pivot-columns>
                <e-column-field field-name="Product" field-caption="Product"></e-column-field>
            </e-pivot-columns>
            <e-pivot-values>
                <e-value-field field-name="Amount" field-caption="Amount"></e-value-field>
            </e-pivot-values>
        </e-data-source>
        <e-scales>
            <e-circular-scales show-ranges="true" radius="150" show-scale-bar="true" size="1" show-indicators="true" show-labels="true">
                <e-border width="0.5"></e-border>
                <e-pointer-collections>
                    <e-pointers show-back-needle="true" back-needle-length="20" length="125" width="7"></e-pointers>
                    <e-pointers type="Marker" marker-type="Diamond" distance-from-scale="5" placement="Center" background-color="#29A4D9" length="25" width="15"></e-pointers>
                </e-pointer-collections>
                <e-tick-collections>
                    <e-ticks type="Major" distance-from-scale="2" height="16" width="1" color="#8c8c8c"></e-ticks>
                    <e-ticks type="Minor" height="6" width="1" distance-from-scale="2" color="#8c8c8c"></e-ticks>
                </e-tick-collections>
                <e-circular-range-collections>
                    <e-circular-ranges distance-from-scale="-5" background-color="#fc0606">
                        <e-border color="#fc0606"></e-border>
                    </e-circular-ranges>
                    <e-circular-ranges distance-from-scale="-5"></e-circular-ranges>
                </e-circular-range-collections>
                <e-custom-label-collections>
                    <e-circular-custom-labels color="#666666">
                        <e-custom-position x="180" y="290"></e-custom-position>
                        <e-custom-font size="10px" font-family="Segoe U" font-style="Normal"></e-custom-font>
                    </e-circular-custom-labels>
                    <e-circular-custom-labels color="#666666">
                        <e-custom-position x="180" y="320"></e-custom-position>
                        <e-custom-font size="10px" font-family="Segoe U" font-style="Normal"></e-custom-font>
                    </e-circular-custom-labels>
                    <e-circular-custom-labels color="#666666">
                        <e-custom-position x="180" y="150"></e-custom-position>
                        <e-custom-font size="10px" font-family="Segoe U" font-style="Normal"></e-custom-font>
                    </e-circular-custom-labels>
                </e-custom-label-collections>
            </e-circular-scales>
        </e-scales>
        <e-label-format-settings decimal-places="2"></e-label-format-settings>
    </ej-pivot-gauge>

    The above code will generate a simple pivot gauge as shown in the following screenshot:

    OLAP

    This section covers the information required to populate a simple pivot gauge with OLAP data source.

    Initialize pivot gauge

    Before initializing the pivot gauge, empty the contents of Index.cshtml file under Views > Home folder and add the following codes:

  • cshtml
  • <ej-pivot-gauge id="PivotGauge1"></ej-pivot-gauge>

    Populate pivot gauge with data source

    Initializes the OLAP data source for the pivot gauge control as shown below:

  • cshtml
  • <ej-pivot-gauge id="PivotGauge1" background-color="transparent" load="onLoad">
        <e-data-source catalog="Adventure Works DW 2008 SE" cube="Adventure Works" data="//bi.syncfusion.com/olap/msmdpump.dll">
            <e-pivot-rows>
                <e-row-field field-name="[Date].[Fiscal]"></e-row-field>
            </e-pivot-rows>
            <e-pivot-columns>
                <e-column-field field-name="[Customer].[Customer Geography]"></e-column-field>
            </e-pivot-columns>
            <e-pivot-values>
                <e-value-field axis="Column">
                    <e-measures>
                        <e-measure-items field-name="[Measures].[Internet Sales Amount]"></e-measure-items>
                    </e-measures>
                </e-value-field>
            </e-pivot-values>
        </e-data-source>
        <e-scales>
            <e-circular-scales show-ranges="true" radius="150" show-ticks="true" show-pointers="true" show-scale-bar="true" size="1" show-indicators="true" show-labels="true">
                <e-border width="0.5"></e-border>
                <e-pointer-collections>
                    <e-pointers show-back-needle="true" back-needle-length="20" length="125" width="7"></e-pointers>
                    <e-pointers type="Marker" marker-type="Diamond" distance-from-scale="5" placement="Center" background-color="#29A4D9" length="25" width="15"></e-pointers>
                </e-pointer-collections>
                <e-tick-collections>
                    <e-ticks type="Major" distance-from-scale="2" height="16" width="1" color="#8c8c8c"></e-ticks>
                    <e-ticks type="Minor" height="6" width="1" distance-from-scale="2" color="#8c8c8c"></e-ticks>
                </e-tick-collections>
                <e-circular-range-collections>
                    <e-circular-ranges distance-from-scale="-5" background-color="#fc0606">
                        <e-border color="#fc0606"></e-border>
                    </e-circular-ranges>
                    <e-circular-ranges distance-from-scale="-5"></e-circular-ranges>
                </e-circular-range-collections>
                <e-custom-label-collections>
                    <e-circular-custom-labels color="#666666">
                        <e-custom-position x="180" y="290"></e-custom-position>
                        <e-custom-font size="10px" font-family="Segoe U" font-style="Normal"></e-custom-font>
                    </e-circular-custom-labels>
                    <e-circular-custom-labels color="#666666">
                        <e-custom-position x="180" y="320"></e-custom-position>
                        <e-custom-font size="10px" font-family="Segoe U" font-style="Normal"></e-custom-font>
                    </e-circular-custom-labels>
                    <e-circular-custom-labels color="#666666">
                        <e-custom-position x="180" y="150"></e-custom-position>
                        <e-custom-font size="10px" font-family="Segoe U" font-style="Normal"></e-custom-font>
                    </e-circular-custom-labels>
                </e-custom-label-collections>
            </e-circular-scales>
        </e-scales>
        <e-label-format-settings decimal-places="2"></e-label-format-settings>
    </ej-pivot-gauge>
    
    <script type="text/javascript">
        function onLoad(args) {
            args.model.dataSource.rows[0].filterItems = { values: ["[Date].[Fiscal].[Fiscal Year].&amp;[2004]"] };
        }
    </script>

    The above code will generate a simple pivot gauge as shown in the following screenshot: