Card: Stacked Bar and Line with single series line and multi series stack.

Reply
Green Belt

Card: Stacked Bar and Line with single series line and multi series stack.

Hi Domors.

 

Firstly, my DS is structured as follows:

Date:     Type:       Actual:       Months Total Forecast:

2017/1   offline       1000           1200

2017/2   email         100             500     

2017/2    refferal      500              500

 

.... and so on.

I have a series of Type defined which is added to the chart along with date and the sum of Actual.

Note, the Months Total Forecast is the forecast for the sum of all the types under the month, its not against each type.

The chart is as follows:

 

image.png

 

What I would like to do is add the Forecast as a Line Series, but simply its not working.

The problem is that 'Type' will not split out into its series.

At best, i receive various versions of this:

 

 

image.png

Is this due to the forecast (FC_MoM...) being a row item rather than stacked/unioned into the DS?

Any help appriciated.

 

Obviously what I hope to achieve is:

image.png

 

Rgds,

K.


Accepted Solutions
Major Brown Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

Hey Kurbz,

 

There is a way I know to solve this, it does require the creation of several beast modes. What you'll need to do is one series for each category (`Type`) in your case.

 

Example:

 

SUM(Case when `Type` = 'organic' then `Revenue` else 0 end)

 

You'd want to do one beast mode for each type. 

 

In your use case, you'd leave the forecast line alone, then add each invididual beast mode onto the graph as its own series. That way it will stack them while still including the forecast line. 

 

Let me know if this works, I'm happy to provide an example and screenshots if needed.

 

 

 

 

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'

All Replies
Major Brown Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

Hey Kurbz,

 

There is a way I know to solve this, it does require the creation of several beast modes. What you'll need to do is one series for each category (`Type`) in your case.

 

Example:

 

SUM(Case when `Type` = 'organic' then `Revenue` else 0 end)

 

You'd want to do one beast mode for each type. 

 

In your use case, you'd leave the forecast line alone, then add each invididual beast mode onto the graph as its own series. That way it will stack them while still including the forecast line. 

 

Let me know if this works, I'm happy to provide an example and screenshots if needed.

 

 

 

 

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Green Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

Thanks XM.
Have seen that approach around. Will give it a try. Many thanks for the input. Cheers.
Green Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

Ah. I know why I previously didn't originally take this solution. It's not dynamic on the stacked series type. Will submit a dynamic solution request Idea for this.
Major Brown Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

@Kurbz

 

You're right, that is one of the drawbacks to this solution, you'd have to add a beast mode each time a new category was added to the data. 

 

It would be nice to have multiple dynamic series on graphs though, I think that's a good suggestion for the ideas exchange.

 

 

**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Green Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

Thanks. Ya only dynamic way is to union the forecast onto the dataset and obviously flag it. But that causes the need to filter the ds when used elsewhere. Ok. Thanks again. I'll try tomorrow. Zzz
White Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

This question was posted nearly 2 years ago, but I came across with the same challenge today... thanks for the work around!!!, it works quite well for me, as the categories are set, but I agree that there shouldn't be a need to do this .

Two years on and is still not implemented... should we keep waiting?Smiley Wink

White Belt

Re: Card: Stacked Bar and Line with single series line and multi series stack.

Any update on this?

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!