Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a stacked chart with values inside segments. I'd like to show sample size (total) on axe (or other place). Could you suggest anything?
Please find attched file.
Thanks,
try this.
Create a new variable
vNew=MinString(Variable)
In chart use an expression
IF(Variable=vNew, Count(TOTAL <Your Time Variable> Variable),'')
![]()
My dataset is different from yours (no time data) but the situation is similar.
Your solution is essentially the same as Matthew's solution offered above, right?
My variable is v_brand. It's calculated as:
v_brand=minstring(Brand)
I have an expression in my bar chart:
if (Brand = v_brand,count(distinct total<[POS]>ResponseID,'')
I'm still finding that if the brands included in each bar are different (i.e, some bars don't have all of the brands represented), the text on axis does not correctly display the count (it shows blank).
Furthermore, the dimension names at the bottom are completely displaced by the blank spaces in the Else statement...
maybe something is wrong. I used this expression for most my charts. I didn't find better solution than this.
I think whether the expression works or not depends on your data. If you have "complete" data (i.e, if you have one value for every dimension in each set of data), then I think it works fine. If some are missing, though (for example, you have no data for one item for a particular month), it seems like issues arise.