Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dear community.
i Need to Display in a bar Chart the following:
a user selects a week_year field (CW 44 Year 2016), which is also the Dimension in the Chart, and the last 12 weeks from that selected week_year value will be displayed.
the expresion shall Display the value of the lask weekday of the week.
this formula Displays the correct value, but i still Need to Display all past 12 weeks, and for each week, the value of the last weekday, shall be displayed.
sum(aggr(sum( {$< date_weekyear=, %date_day_index__id ={'$(=aggr(max(%date_day_index__id),date_weekyear))'},
%date_weekyear__id={">$(vL.FromWeek)<=$(vL.ToWeek)"} >} active12_sum) , date_weekyear)
Note the filter and Dimension is the "date_weekyear" field (in figures as "calendar week")
In the figure, for the CW 44.2016, the value 74.845 is not the value of the last day of that week. I Need to get the last weekday value for the current week for all 12 weeks.
Any ideas on how to achieve this?
thanks
You need Friday's value for the 12 weeks you are seeing?
Sum({$<Weekday = {'Fri'}, date_weekyear=, %date_day_index__id ={'$(=aggr(max(%date_day_index__id),date_weekyear))'},
%date_weekyear__id={">$(vL.FromWeek)<=$(vL.ToWeek)"} >} active12_sum)
Where Weekday field is created in the script like this
WeekDay(Date) as Weekday
I have also removed the Sum(Aggr()) function as I don't see any need to use that
hi, thanks, i used better an if-condition after sum. Before I got the Weekenddate (%date_weekend_day__id) in script. then i got the values for all weeks
final solution looked like this:
sum( {$< date_weekyear=, date_weekyear__id={">$(vL.FromWeek)<=$(vL.ToWeek)"} >}
if(%date_day_index__id=%date_weekend_day__id, active12_sum) )