{"Name":"PiePlot.rdlx-json","Width":"0in","Layers":[{"Name":"default"}],"CustomProperties":[{"Name":"DisplayType","Value":"Page"},{"Name":"SizeType","Value":"Default"},{"Name":"PaperOrientation","Value":"Portrait"},{"Name":"CollapseWhiteSpace","Value":"True"}],"Version":"10.0.1","Page":{"PageWidth":"8.5in","PageHeight":"11in","RightMargin":"0in","LeftMargin":"0in","TopMargin":"0in","BottomMargin":"0in","Columns":1,"ColumnSpacing":"0.5in","PaperOrientation":"Portrait"},"DataSources":[{"Name":"Contoso","ConnectionProperties":{"DataProvider":"JSON","ConnectString":"endpoint=https://demodata.mescius.io/contoso/odata/v1"}}],"ReportSections":[{"Type":"Continuous","Name":"ContinuousSection1","Page":{"PageWidth":"8.5in","PageHeight":"11in","RightMargin":"0.5in","LeftMargin":"0.5in","TopMargin":"0.5in","BottomMargin":"0.5in","Columns":1,"ColumnSpacing":"0in","PaperOrientation":"Portrait"},"Width":"7.5in","Body":{"Height":"7.3in","ReportItems":[{"Type":"chart","Name":"Chart2","ZIndex":1,"DataSetName":"Sales","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Header":{"Style":{"PaddingBottom":"8pt","FontSize":"26pt","Color":"#3da7a8"},"Title":"Sales By Category"},"Footer":{"Style":{"PaddingTop":"2pt","PaddingBottom":"4pt"}},"Palette":"Custom","CustomPalette":["#8fcd37","#f26324","#e40010","#1fd537","#ffca3a","#00b32c","#b3000c"],"PlotArea":{"Axes":[{"LabelStyle":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"LineStyle":{"Border":{"Style":"Solid"}},"MajorGridStyle":{"Border":{"Color":"Gray","Style":"Solid"}},"Plots":["Plot 1"],"Position":"None","Title":"Category","TitleStyle":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"}},{"AxisType":"Y","Format":"p0","LabelStyle":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"LineStyle":{"Border":{"Style":"Solid"}},"MajorGrid":true,"MajorGridStyle":{"Border":{"Color":"Gray","Style":"Solid"}},"Plots":["Plot 1"],"Position":"None","Scale":"Percentage","Title":"Value","TitleStyle":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"}}],"Style":{"PaddingLeft":"24pt","PaddingRight":"24pt","PaddingTop":"12pt","PaddingBottom":"36pt"}},"Plots":[{"Name":"Plot 1","PlotType":"Pie","Config":{"AxisMode":"Radial","Bar":{"Width":1},"ClippingMode":"Fit","SeriesArrangement":"Stack"},"SeriesGroupings":[{"Grouping":{"GroupExpressions":["=Fields!ProductCategory.Value"]}}],"DataSeries":[{"Name":"Series1","Values":[{"Value":"=Sum(Fields!SalesAmount.Value)"}],"Label":{"Value":"=Sum(Fields!SalesAmount.Value)/Sum(Fields!SalesAmount.Value,\"Plot 1\")","Offset":16,"Style":{"FontSize":"14pt","Border":{"Color":"Gainsboro","Width":"0.25pt"},"Format":"p2"},"TextPosition":"Outside","ConnectingLineStyle":{"Color":"#e6e6e6","Style":"Solid","Width":"0.25pt"}},"ToolTip":{"Value":"Fields!ProductCategory.Value & \"Chr(13)Quantity\" & \" \" & \"SalesQuantity\" & \"Chr(13)Amount\" & \" \" & Format(\"=Sum(Fields!SalesAmount.Value)\", \"C2\")"}}],"ColorSeries":{"Orientation":"Horizontal","Position":"Top","Style":{"PaddingTop":"4pt","PaddingBottom":"20pt"},"TextStyle":{"FontSize":"9pt","Color":"#3c3c3c"},"Mode":"SeriesGroups"},"SizeSeries":{"Orientation":"Horizontal"},"ShapeSeries":{"Orientation":"Horizontal"}}],"Top":"0.8in","Width":"7.5in","Height":"6.5in"}]}}],"DataSets":[{"Name":"Sales","Fields":[{"Name":"DateKey","DataField":"DateKey"},{"Name":"ChannelKey","DataField":"ChannelKey"},{"Name":"ProductKey","DataField":"ProductKey"},{"Name":"UnitCost","DataField":"UnitCost"},{"Name":"ReturnAmount","DataField":"ReturnAmount"},{"Name":"DiscountAmount","DataField":"DiscountAmount"},{"Name":"SalesAmount","DataField":"SalesAmount"},{"Name":"SalesQuantity","DataField":"SalesQuantity"},{"Name":"ProductCategory","Value":"=Switch(Fields!ProductKey.Value < 116, \"Audio\", Fields!ProductKey.Value >= 116 And Fields!ProductKey.Value < 338, \"TV and Video\", Fields!ProductKey.Value >= 338 And Fields!ProductKey.Value < 944, \"Computers\", Fields!ProductKey.Value >= 944 And Fields!ProductKey.Value < 1316, \"Cameras\", Fields!ProductKey.Value >= 1316, \"Cell Phones\")"},{"Name":"SalesChannel","Value":"=Switch(Fields!ChannelKey.Value = 1, \"Store\", Fields!ChannelKey.Value = 2, \"Online\", Fields!ChannelKey.Value = 3, \"Catalog\", Fields!ChannelKey.Value = 4, \"Reseller\")"},{"Name":"NetIncome","Value":"=Fields!SalesAmount.Value - Fields!UnitCost.Value - Fields!DiscountAmount.Value - Fields!ReturnAmount.Value"}],"Query":{"DataSourceName":"Contoso","CommandText":"uri=/FactSales?$select=DateKey, ProductKey, SalesAmount,UnitCost,ReturnAmount,DiscountAmount, ChannelKey,SalesQuantity;jpath=$.value.*"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"}]}