Forum Discussion

pbiallday's avatar
pbiallday
Regular Visitor
2 years ago
Solved

Don't Summarize in bar chart?

I have data that includes a product name, price and how long it took to sell (see table below).   I create a stacked bar chart and put Price in Y axis and Time to Sell in the X axis. However, it wi...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

this is the formula = UNICHAR(8203), this is a zero width space.
REPT (UNICAR(8203), [Time to Sell])  - here we repeat this several times .
and so when we pass this along the Y axis, it will not be read, but it will create a uniqueness for each row.

pbiallday's avatar
pbiallday
Regular Visitor
2 years ago

Thank you, I accepted the solution. Could you explain one more thing, I understand the formula adding the zero width space, but if you have two rows with the same value (like B & C with $200 each) then if you add zero width to each, they are still the same and not unique (at least it would seem). So how does that actually make those unique?

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    here's another variant

    • pbiallday's avatar
      pbiallday
      Regular Visitor
      2 years ago

      This works better but after experimenting I get the same result by dragging the name field into the x-axis. So this led me to something that'll work for me so appreciate that.

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    2 years ago

    uniqueness depends on the value in the Time to sell column
    , if there are $200 in A and B and $40 in the Time column, then there will be no uniqueness here, you need to look for another way