Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, i'm struggling to create a 100% stacked bar chart. I have a stacked chart but it doesn't add up to 100%. Please i need help.
My dimension is: If(WildMatch(Product,'Gold','Silver','Bronze'), Product,Null())
and my measure is:
sum(
{$
<
Product={'Gold','Silver','Bronze'},
HousePK=P({1<Product={'Remote'}>}HousePK)>}
HouseCount)
/
sum(total<HousePK>
{$
< Product={'Gold','Silver','Bronze'},
HousePK=P({1<Product={'Remote','Featured Employer','Featured House','Man of the Week','Sponsored House','Spotlight Ad','Spotlight','Mobile '}>}HousePK)
>
}
HouseCount)
the above set analysis is just one of the measures against all the product listed and it's adding up to 150% and that's not what i'm looking for.
I want to create a stacked bar chart where it's showing a subset of all the records in the Product field (Product={'Remote','Featured Employer','Featured House','Man of the Week','Sponsored House','Spotlight Ad','Spotlight','Mobile '}) to reach the total of 100%. I hope i'm making sense
Can you share some sample data.
please post a sample application showing this behaviour.