Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ranking, Name, Month, Value
2, A,Jan,0
5, A, Jan, 1.56
2, A,Feb,0
5,G,Feb,0.5
5,G,Feb,0.76
5,G,Feb,2.16
4, H, Feb, 81.63
6, I, Mar, 9.60
]; I am unable to get the correct average in my sub Total?
When i use the formula in expression Avg(Value)
Actually i should get February total average as 41.38
i am getting as 21.26
Thanks in Advance
Thanks for the help everyone:)
Hi,
I need Avg for all the Years as below.
Year | Category1 | Category2 | Category3 | Category4 |
Avg | 2534.0% | 786.0% | 786.0% | 786.0% |
2017 | ||||
Jan | 600 | 700 | 660 | 300 |
Feb | 50 | 50 | 50 | 50 |
Mar | 5300% | 56% | 56% | 56% |
2018 | ||||
Apr | 100 | 140 | 500 | 900 |
Jan | 40 | 40 | 40 | 40 |
Feb | 2300% | 2300% | 2300% | 2300% |
Mar | ||||
2019 | ||||
Jan | 100 | 104 | 600 | 1900 |
Feb | 20 | 20 | 20 | 20 |
Mar | 2% | 2% | 2% | 2% |
Appreciate the above results.
Hi,
I have 2 charts (attached) those used calculated dimensions and when I select 1 bar in 1 chart(Last 30 days) then,
2nd chart (ActInAct Customers) is also applying filter and showing blank(attched).
I dont nees to change the 2nd chart should not reflect on any values and should show all the values.
below are the calc dimensions in 2nd chart (ActInAct Customers):
dimension:
=Aggr(if(CUSTOMER_IN_LAST_3_YEARS_IND='Y' and CUSTOMER_IN_LAST_2_YEARS_IND='N','Last 3Yrs Active but InActive Last 2yrs',
if(CUSTOMER_IN_LAST_2_YEARS_IND='Y' and CUSTOMER_IN_LAST_1_YEARS_IND='N','Last 2Yrs Active but InActive Last 1yr',
if(CUSTOMER_IN_LAST_1_YEARS_IND='Y' and CUSTOMER_IN_LAST_90_DAYS_IND='N','Last 1Yr Active but InActive Last 90days',
if(CUSTOMER_IN_LAST_90_DAYS_IND='Y' and CUSTOMER_IN_LAST_30_DAYS_IND='N','Last 90days Active but InActive Last 30days'))))
,CHK_CustID)
Measure:
count({1}CHK_CustID) - added 1 on measure also but still not working.
Appreciate the solution.
Thanks