Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

Cumulative count in bar chart with two dimension

Hello ,

I have to cumulate count in a bar chart object , 

test.PNG

I used this set analysis it works but there is two wrong values dates :

Aggr(RangeSum(Above(Total Count(distinct{$<New_Category={"IV1/IV2 -A"}>}[Application Services name])
, 0, RowNo())), Envirement, (Migration_date,NUMERIC, ASCENDING))

2.PNG

Any ideas please ? 

 

Thank you 

 

@sunny_talwar 

1 Reply
PradeepK
Creator II
Creator II

Avoid doing it in expression.. Look into : The-As-Of-Table 

Also as per shared screenshot it seems like issue with "2021-10" and "2021-11" is due to missing DEV, STD dimension data.

Please share some sample data to debug it further.