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

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.