4 Replies Latest reply on Feb 28, 2018 8:43 AM by Sashank Kammili

# How we do show max(value) at dimension level

Hi, i have the below calculated field. I am doing this for a radial bar chart

[Value]*270/{MAX([Value])}

now, i have a period dimension and it has data as previous year, this year and this month. What i want to do is when i apply this calculated field  [Value]*270/{MAX([Value])} in such a way that it applies that max(value) at each period level. i.e for period = previous year, this year and this month. Would like to know how to accomplish this. please help me with this

• ###### 1. Re: How we do show max(value) at dimension level

Hi, Sashank

Have you tried something similar like this?

Value]*270/{Fixed [period]:MAX([Value])}

ZZ

• ###### 2. Re: How we do show max(value) at dimension level

Hi, i haven't tried that. Will try that. My actual calculated field is below

• CASE  [Type]
• WHEN 1 THEN 0
• WHEN 2 THEN [Value]*270/{MAX([Value])}
• END

so, in the above calculated field, I can give that whatever you mentioned. Will that work.

• ###### 3. Re: How we do show max(value) at dimension level

I think so, you can give it a try and see whether the result meets your requirement. If not, can you provide a sample workbook?

ZZ

• ###### 4. Re: How we do show max(value) at dimension level

thanks for that, it worked. now I have another question, I have a bubble chart with visits count, where I need visits count for top 9 products and same thing, it has top 9 visits counts for products at period level (period = this year, previous year, this month), I created rank calculated field like the below

RANK(SUM([Visits])), I applied this to the filter to show top 9. My ques here is, my bubble chart is occupying whole space when I last year in filter drop down, but when I give this year and this month, the chart is not occupying whole space even though I made it fit to entire view. One reason could be visit count is much higher in last year than this year. how can I fix this, lyk whatever the dropdown I apply, that chart should occupy the entire view