Continues Stacked Bar Chart

[zivhimmel]

Hi,

I'm trying to define a stacked bar chart as continues but cannot find a "type" field for that.

I'm showing leads and users per channel. For example, 1000 leads, out of which 300 became users - currently it shows as 1000+300 = 1300, but I want to show 700+300.

Thanks in advance for your help.

[Eric_Zhang]

---

@zivhimmel wrote:

Hi,

I'm trying to define a stacked bar chart as continues but cannot find a "type" field for that.

I'm showing leads and users per channel. For example, 1000 leads, out of which 300 became users - currently it shows as 1000+300 = 1300, but I want to show 700+300.

Thanks in advance for your help.

---

@zivhimmel

@CahabaData's seems the only approach. To find any other possible approach, can you eleborate what are the bold part in your post? And what is your data like, how users and leads are distinguished?

[zivhimmel]

Nah..that's ok. The proposed solution is good.

Thanks !

[CahabaData · Accepted solution]

so to show 700 - that number must first exist as a data point.  You want first to use either a measure or a calculated column that creates that number.  Then you use this new field in your display.

[zivhimmel]

Thank you ! Can do. Not ideal though so if anyone can think of another way, would be great.