Summarize opportunity by product

I want to replicate a SF chart in Skuid.  Simply a column chart with the sum of opportunities split by product.  Data axes = Amount; category axes = Product Name.  How do I get product name as a category field?


I did this using an Aggregate model on Opportunity Line Items. I sum on Opportunity.Amount and Group By Product.Name. Is this what you are after?

<skuidpage unsavedchangeswarning="yes" personalizationmode="server" showsidebar="true" useviewportmeta="true" showheader="true">    <models>
        <model id="OppByProduct" limit="" query="true" createrowifnonefound="false" datasource="salesforce" type="aggregate" sobject="OpportunityLineItem">
                <field id="Opportunity.Amount" name="sumOpportunityAmount" function="SUM"/>
            <groupby method="simple">
                <field id="Product2Id" name="product2Id"/>
                <field id="Product2.Name" name="product2Name"/>
        <skuidvis__chart model="OppByProduct" maintitle="{{Model.labelPlural}}" type="column" uniqueid="sk-PQVRj-123">
                <axis id="axis1"/>
                <axis id="categories" categorytype="field" field="product2Name"/>
                <series valuefield="sumOpportunityAmount" splittype="none"/>
            <legend layout="horizontal" halign="center" valign="bottom"/>
        <styleitem type="background" bgtype="none"/>



Thanks Bill, that is what I needed.  Although, I have an oppty chart that responds to table filters for Owner, Close Date, stage and it is also filterable on through a opptylineitem subquery condition on the oppty model.  Ideally, I would like to have that chart with as a category.  For now I’ll move forward with two visualisations. 

Got into building my chart and your solution, Bill, will deliver everything I need, AWESOME!!