How to Create a Histogram show each person balance

[eddywong71]

Hi All,

I have a KPI Average Balance expression like below:

avg(
Aggr(
sum({$<[Exit Indicator] = {0}>}[Balance] ) , [Customer ID])

The output =350.

For Example

ID  Balance  Month  Product                    

1    200          12         apple                

1    300          12         orange

2    100          12         apple

3    400          12         apple

4    400          12         apple

Expected Result

ID  Balance  Month

1    500          12                      

2    100          12     

3    400          12         

4    400          12  

The Histogram should plot  500 100 400 400

However, i dont know what is the dimension in Histogram which can show the distribution of Balance by each customer. 

Aggr(
sum({$<[Exit Indicator] = {0}>}[Balance] ) , [Customer ID])

No result in Histogram (The Chart is not Displayed Because it Contains Only Undefined Values.)

But have result in Table Dimension

Balance 

500                               

100                                 

400           

[eddywong71]

Can anyone help

[MarcoWedel]

please post some sample data and your expected result

[eddywong71]

Hi MarcoWedel,

Please find my sample data and expected result on the above.

[eddywong71]

Can anyone help

[MarcoWedel]

Hi,

maybe using a bar chart with 

dimension:

Aggr(Sum({$<[Exit Indicator] = {0}>}[Balance] ) , [Customer ID])

and measure:

Count({$<[Exit Indicator] = {0}>} distinct [Customer ID])

could work for you?

hope this helps

Marco