Weekly and YTD Value in combo chart

[ishanbansal1204]

Hi Experts,

I have a combo chart where the dimensions are week and then the first measure that i am using is the sum(count) at  a week level

but i am not getting the YTD value

e.g.

for weeek 1 value will be 10 and YTD will be10

for week 2 value will be 20 and YTD will be 30

THis should be grouped at week and year level.

I have attached the sample file.

[ishanbansal1204]

Thanks for the file.

But in the file that you had shared

apply filter on date and select last few weekyear filter

in that case YTD values are calculated based on the filter selected but that should not be the case.

Please find the updated file and let me know.

Thanks.

The attachment is in the main tread.

[ishanbansal1204]

Hi Eromiya Simon,

This will work fine if no filters are applied. if i apply filter on week and select few weeks then YTD values are calculated only for the selected week but YTD has to be calculated irrespective of the week selected.

[eromiyasimon]

you can use this expression

Sum(Aggr(rangesum(Above(Total sum({<WEEK>} COUNT),0,RowNo(Total))),WEEK))

or

you can simply detach the chart or you can setup alternative state to preserve the values being changed while the selection has been made.

[tresesco]

In that case, try the expression below:

Sum(Aggr(rangesum(Above(Total sum({<WEEK>} COUNT),0,RowNo(Total))),WEEK))

[antoniotiman]

See Attachment

[ishanbansal1204]

Not Working. Showing some incorrect values.

[ishanbansal1204]

Not Working. Showing some incorrect values.

[ishanbansal1204]

Hi Antonio,

The calculation was done in the load script as per your file that you shared.

Is there any possibility that i can use some calculation in the measure or in the dashboard itself rather than in the load script.?

[eromiyasimon]

hi ishan,

i donno why you are getting error,

use the attached QVW.

[tresesco]

Since your dimension is WeekYear, you have to change the expression accordingly like:

Sum(Aggr(rangesum(Above(Total sum({<WeekYear>} COUNT),0,RowNo(Total))),WeekYear))