How to Create a Histogram show each person balance (Include Sum)

eddywong71 — Thu, 08 Feb 2024 08:01:32 GMT

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])

Re: How to Create a Histogram show each person balance (Include Sum)

eddywong71 — Thu, 08 Feb 2024 08:00:44 GMT

Can anyone help

topic Re: How to Create a Histogram show each person balance (Include Sum) in App Development

How to Create a Histogram show each person balance (Include Sum)

Re: How to Create a Histogram show each person balance (Include Sum)