Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a percentage of a number that I want to show on a drill chart. For example out of 20 attempts 10 were successful in the first week in December, 15 out of 20 in the second week, 5 out of 20 in the third week and 10 out of 20 in the fourth week. So the percentages by week are 50%, 75%, 25% and 50%. When I am showing months I would like it to show 50% and then drill down to show the different weeks. What format should I use for the expression?
Your Percentage is based on your dimension right? So just add the Drill with Year,Month and Week in order..
Upload some sample data for what exactly you are looking for
Selva
Block and Mekko Chars are the better solution for this type of problem.
Still we can use other charts also, let us have your sample file.