{"Name":"ClusteredBarPlot.rdlx-json","Width":"6.5in","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":"6in","ReportItems":[{"Type":"chart","Name":"Chart1","DataSetName":"Sales","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"Header":{"Style":{"PaddingTop":"12pt","PaddingBottom":"6pt","FontSize":"24pt","Color":"#3da7a8"},"Title":"Sales by Category and Channel"},"Footer":{"Style":{"PaddingLeft":"6pt","PaddingRight":"6pt","PaddingTop":"6pt","PaddingBottom":"4pt"},"HAlign":"Right"},"Palette":"Custom","CustomPalette":["#f26324","#1fd537","#e40010","#8fcd37","#00b32c","#b3000c","#ffca3a"],"PlotArea":{"Axes":[{"LabelStyle":{"Color":"#808080","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"6pt","PaddingBottom":"12pt"},"LineStyle":{"Border":{"Color":"#ccc","Style":"Solid","Width":"2pt"}},"MajorGridStyle":{"Border":{"Color":"Gray","Style":"Solid"}},"Plots":["Plot 1"],"TitleStyle":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt"}},{"AxisLine":false,"AxisType":"Y","Format":"c2","LabelStyle":{"FontSize":"9pt","Color":"#808080","PaddingLeft":"2pt","PaddingRight":"12pt","PaddingTop":"2pt","PaddingBottom":"2pt"},"LineStyle":{"Border":{"Color":"#3c3c3c","Style":"Solid","Width":"0.5pt"}},"MajorGrid":true,"MajorGridStyle":{"Border":{"Color":"#ccc","Style":"Dashed","Width":"0.25pt"}},"MajorTickSize":"2pt","MajorTickStyle":{"Border":{"Color":"#808080","Style":"Dotted"}},"MajorUnit":"50000","Max":"450000","Min":"0","Plots":["Plot 1"],"TitleStyle":{"PaddingLeft":"2pt","PaddingRight":"12pt","PaddingTop":"2pt","PaddingBottom":"2pt"}}],"Style":{"PaddingRight":"5pt"}},"Plots":[{"Name":"Plot 1","PlotType":"Bar","Config":{"Bar":{"Overlap":-0.1,"Width":0.75},"SwapAxes":true},"SeriesGroupings":[{"Grouping":{"Name":"Plot 1_SalesChannel_Group","GroupExpressions":["=Fields!SalesChannel.Value"]}}],"CategoryGroupings":[{"Grouping":{"Name":"Plot 1_ProductCategory_Group","GroupExpressions":["=Fields!ProductCategory.Value"]},"Sorting":[{"Value":"=Fields.Item(\"Net Sales\").Value","Direction":"Descending"}]}],"DataSeries":[{"Name":"Series1","Values":[{"Value":"=Sum(Fields.Item(\"Net Sales\").Value)"}],"Label":{"Style":{"Color":"#ffffff"},"TextPosition":"Center","ConnectingLineStyle":{"Color":"#000000"}}}],"ColorSeries":{"Orientation":"Horizontal","Position":"Top","Style":{"PaddingRight":"10pt","PaddingTop":"4pt","PaddingBottom":"20pt"},"Mode":"SeriesGroups"},"SizeSeries":{"Orientation":"Horizontal"},"ShapeSeries":{"Orientation":"Horizontal"}}],"Top":"0.4in","Width":"7.5in","Height":"5.6in"}]}}],"DataSets":[{"Name":"Sales","Fields":[{"Name":"ChannelKey","DataField":"ChannelKey"},{"Name":"ProductKey","DataField":"ProductKey"},{"Name":"UnitCost","DataField":"UnitCost"},{"Name":"ReturnAmount","DataField":"ReturnAmount"},{"Name":"DiscountAmount","DataField":"DiscountAmount"},{"Name":"Net Sales","DataField":"SalesAmount"},{"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":"Net Income","Value":"=Fields.Item(\"Net Sales\").Value - Fields!UnitCost.Value - Fields!DiscountAmount.Value - Fields!ReturnAmount.Value"},{"Name":"SalesChannel","Value":"=Switch(Fields!ChannelKey.Value = 1, \"Store\", Fields!ChannelKey.Value = 2, \"Online\", Fields!ChannelKey.Value = 3, \"Catalog\", Fields!ChannelKey.Value = 4, \"Reseller\")"}],"Query":{"DataSourceName":"Contoso","CommandText":"uri=/FactSales?$select=ProductKey,SalesAmount,UnitCost,ReturnAmount,DiscountAmount, ChannelKey&$filter=ProductKey+gt+337;jpath=$.value.*"},"CaseSensitivity":"Auto","KanatypeSensitivity":"Auto","AccentSensitivity":"Auto","WidthSensitivity":"Auto"}]}