Forum Discussion

zivhimmel's avatar
zivhimmel
Resolver I
10 years ago
Solved

Continues Stacked Bar Chart

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.

 

  • 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.

4 Replies

  • CahabaData's avatar
    CahabaData
    Memorable Member

    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's avatar
      zivhimmel
      Resolver I

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

       

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    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's avatar
      zivhimmel
      Resolver I

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

      Thanks !