How do I show totals in a pivot table chart?

SeparateFiction
SeparateFiction Registered Posts: 7 ✭✭✭✭

I have stacked two datasets (Alerts & Filings).

I have used the the chart functionality to pivot and colour code the data (attached).

How do I show a new column that provides the percentage of alerts by filings? In the attached example the new percentage column would ideally show me 0.9% (18/2043).

I couldn't for the life of me get anything to work, including using the pivot recipe which just blows my mind every time I try something with it.

Answers

  • ATsao
    ATsao Dataiker Alumni, Registered Posts: 139 ✭✭✭✭✭✭✭✭

    Hi there,

    You won't be able to create a new column that doesn't already exist in the underlying dataset within the chart itself. However, I would suggest using a Prepare recipe to create a new "Percentages" column by using a formula. For example, something like the following:

    Screen Shot 2020-03-03 at 10.06.13 AM.png

    Then, you could always use/include this new column that you just created in whatever charting you're trying to build. As for the pivot recipe, more information about how this recipe works can be found in our documentation here:

    https://doc.dataiku.com/dss/latest/other_recipes/pivot.html

    Thanks,

    Andrew

Setup Info
    Tags
      Help me…