0

Description:

Einstein Analytics dashboards contains different chart types to select. Column and stacked column charts are only two out of tens available.

Column Chart

Stacked Column Chart

Question

Is it possible to use column bars and stacked column bars in one chart like in the figure below?

Column and Stacked Column bars in one chart

Improve this question

1 Answer 1

Reset to default
0

enter image description here

I managed to get two columns side by side with the actual data. Here I use SAQL statements to load the data and transform it into two sets (targeted revenue and actual revenue) then union both sets while setting the null values to 0, lastly order them by year and sum of values of both sets side by side. Additional steps require use of 'stacked column' charts while keeping year on the horizontal axis, sums in vertical axis and stacking the values by status (high, medium, low) and setting the axis mode to 'single'. Final data table looks like this. enter image description here

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .