Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want to find average based on week days.i.e if 1 monday has passed in a month then value/1,if 2 monday or tue wed etc has passed in a month then sum(value) for 2 monday or tue or wed etc /2 and so on
please find screenshot 
Accepted Solutions
1) Create a Month Field in your script:
Month(Date) as Month.
2) Use a simple table chart and put:
As dimensions:
Month
Date,
week
As measures:
YourMeasure (for testing) : sum(Measure)
Cumulative by weekDay (by Month)
aggr(
RangeSum(Above(
sum(measure)
,0,RowNo())),Month, Week,Date)
Nb of occurences of a weekday in a month:
aggr(rangesum(above( count({1}Week),0,RowNo())),Month,Week,Date)
Average : cumul/nb :
aggr(
RangeSum(Above(
sum(measure)
,0,RowNo()))
/
rangesum(above( count({1}Week),0,RowNo()))
,Month, Week,Date)
Result:
1) Create a Month Field in your script:
Month(Date) as Month.
2) Use a simple table chart and put:
As dimensions:
Month
Date,
week
As measures:
YourMeasure (for testing) : sum(Measure)
Cumulative by weekDay (by Month)
aggr(
RangeSum(Above(
sum(measure)
,0,RowNo())),Month, Week,Date)
Nb of occurences of a weekday in a month:
aggr(rangesum(above( count({1}Week),0,RowNo())),Month,Week,Date)
Average : cumul/nb :
aggr(
RangeSum(Above(
sum(measure)
,0,RowNo()))
/
rangesum(above( count({1}Week),0,RowNo()))
,Month, Week,Date)
Result:
You know? I'm on a mission right now, I have my own projects and this did not keep me from creating apps and inline models to try to help community members because I know how it feels to not know the answer; I've been there.
So please, AT LEAST, you can thank anyone willing to sacrifice time and effort to replicate ur data, search for a solution and contribute to your well being.
That said, this'll work if u replicate exactly what I shared with you, even if you sort by date:
Have a nice day.
