Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm using set analysis combined a Linear Gauge mini chart. However, I'm having an issue with the lower bound (i.e., if the value is less than zero, my chart will not draw). I was able to get the Max bound set using the following logic:
If(vComparePeriod = 'Year', max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}>} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}>} ReportedPrice)) -1, grpCGeoPartnerProduct)), If(vComparePeriod = 'Quarter', max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalQuarter={'$(vCurrentQtr)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalQuarter={'$(vCurrentQtr)'} >} ReportedPrice)) -1,grpCGeoPartnerProduct)), If(vComparePeriod = 'Month', max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalMonth={'$(vCurrentMonth)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalMonth={'$(vCurrentMonth)'} >} ReportedPrice)) -1, grpCGeoPartnerProduct)), If(vComparePeriod = 'Week', max(total aggr((Sum({$<FiscCalYr={'$(CurrentYear)'}, FiscCalWk={'$(vCurrentWeek)'} >} ReportedPrice) / Sum({$<FiscCalYr={'$(PreviousYear)'}, FiscCalWk={'$(vCurrentWeek)'} >} ReportedPrice)) -1, grpCGeoPartnerProduct)) ) ) ))
How do I test for the lowest value instead of the highest value? I tried replacing "max" with "min" but it didn't work.
I should mention that I tried hard-coding a fixed value & that still did not work. Any ideas what is causing this problem?