Adjust scale for drill down dimension separately?

[#1]

Hey,

I have a drill down bar chart, where my dimensions go from weeks to days. My source is from an SQL database, and my right of now it is displaying 54 weeks in a year and 32 days for each month. I was wondering how I can adjust my scale to to display my weeks from 0.5 to 52.5 weeks and days from 0.5 to 31.5  (if I try adjusting from 1 to 31, then my bar is cut off). I played around with the static max and min, and was able to set my min to 0.5 for both weeks and days. However, when I adjust my max for days to 32.5, it also adjusts my max weeks from 0.5 to 32.5. Anybody know how to fix this?

I appreciate any help or direction,

Thanks,

Cliff

[#2 · Accepted solution]

in the static max use the below expression instead of static values:

=If(GetSelectedCount(weeks)=1,52.5,31.5)

Kiran Rokkam.

[#3]

Thanks Kiran,

I got to work like I wanted it too but I switched the order of numbers..=If(GetSelectedCount(Weeks)=1,31.5,52.5)

I appreciate the help!!

Cliff