Plot running total in cluster bar combo chart

[Tanisha_Shetty]

Hi All,

How do I plot a running total that I’ve calculated using runningSum in a cluster bar combo chart. I can visualize it in a pivot table( as I can place all the partition fields in the rows and hide them). Trying to do this similarly in a bar/ cluster bar combo chart I’m unable to place {marketplace_id},{content_type} in the rows as it requires me to place

Formula: runningSum(sum(revenue), [{Weeks from Release} ASC], [{marketplace_id},{content_type}])
Error:

Thanks,
Tanisha

[Max]

Unfortunately you need to have both of them referenced. Have you tried adding the marketplace_id as a color?

[Tanisha_Shetty]

Hi Max,

I tried adding the marketplace_id as a color and still got the error.

What worked is - concatenating both the fields [{marketplace_id},{content_type}] into a new calculated field and referenced that in the color fields.

Thanks,
Tanisha

[Max]

Thanks for posting the solution!

[Kristin]

Thanks @Tanisha_Shetty for helping out the Community with your post!