Hi All,
I have a KPI Average Balance expression like below:
avg(
Aggr(
sum({$<[Exit Indicator] = {0},
MonthDiff = {">=$(vmob)<=$(vmob)"} ,[Join Month2] = {"$(='>=' & Date(MonthStart(Max(Month),- $(vmob))) & '<=' & Date(MonthStart(Max(Month),- $(vmob))))"}>}[Balance] ) , [Customer ID])
The output =200.
However, i dont know what is the dimension in Histogram which can show the distribution of Balance by each customer.
No result in Histogram (The Chart is not Displayed Because it Contains Only Undefined Values.)But have result in Table Dimension on below expression
Aggr(
sum({$<[Exit Indicator] = {0},
MonthDiff = {">=$(vmob)<=$(vmob)"} ,[Join Month2] = {"$(='>=' & Date(MonthStart(Max(Month),- $(vmob))) & '<=' & Date(MonthStart(Max(Month),- $(vmob))))"}>}[Balance] ) , [Customer ID])
