Monday, March 19, 2018

Adding Subtotals to Einstein Analytics Table

Tables in Einstein Analytics are quite flexible.  They can be very useful for calculating columns and manipulating data.  One feature they lack is the ability to show subtotals. Here's a video walkthrough of how you can add subtotals to a pivot table with SAQL.


6 comments:

  1. can we build charts and map on top of this data will we get the grand totals as well in map when we hover over it say region wise grand totals

    ReplyDelete
  2. I believe you would need to have a spot in the map that is keyed to the value in the grand total row, as it would just appear as data to the chart.

    ReplyDelete
  3. hi, i need help in populating dyanmic column name based on month- ex- say month is july then column will be added from july , augst, sept, in dashboard data should render based on that.

    ReplyDelete
    Replies
    1. You will want to post to the Salesforce Trailblazer community, Einstein Analytics group - https://success.salesforce.com/_ui/core/chatter/groups/GroupProfilePage?g=0F9300000009MBP

      There are a lot of folks that will provide suggestions

      Delete
  4. What if I want to do column total, subtotal?

    ReplyDelete
    Replies
    1. Hi, Did you find an answer for column total/sub-total? I am looking for the same.

      Delete