Distribution plot: show always 0 as baseline by drilling

petergassert — Sat, 16 Nov 2024 17:37:54 GMT

Good morning,

I am trying to focus my distribution plot, that always the 0 is in the middle.
Challange is, that the dimension is a drill down with 2 levels. First includes a formula, to cumulate company codes.

With min and max value this works fine on the first level by using the

Min(Aggr(Sum(CF_In_CUR_Amount), CF_CompanyPair))*1.1

By selecting a Company Pair and the next level will be opened to a monthly level, i would need to change the grouping to show the 0 as Baseline again.

Do you have any idea, how to set up the diagramm to always show the 0.

Points: Category Pair
Y-achsis: Drill down (Company Pair , YearMonth)
Measure: Sum(Value)

Re: Distribution plot: show always 0 as baseline by drilling

petergassert — Tue, 12 Jan 2021 09:23:55 GMT

Found the solution myself:

Used following formula in a Minimum and Maximum Variable:
=if(GetPossibleCount(CF_CompanyPair)=1
,Min/Max(Aggr(Sum(CF_In_CUR_Amount),CF_CategoryPair, CF_MonthID))*1.1
,Min/Max(Aggr(Sum(CF_In_CUR_Amount),CF_CategoryPair, CF_CompanyPair))*1.1
)

These variables did I use to check if the Min/Max < or > 0
Min: = if(num($(vDistPlotMin))<=0 , if(num($(vDistPlotMax))<=0 , num($(vDistPlotMin)) ) , 0)
Max: = if(num($(vDistPlotMax))<=0 ,0, num($(vDistPlotMax)) )

topic Re: Distribution plot: show always 0 as baseline by drilling in App Development

Distribution plot: show always 0 as baseline by drilling

Re: Distribution plot: show always 0 as baseline by drilling