Chart with months as dimension: Current month's data the same as last's

[#1]

Hi,

I have a chart:

It sums data by month.

I want the current month (12), instead of being the actual data, to be the same as the month before it (11).

How can it be done?

The attached qvw has the relevant chart.

Thanks!

[mdmukramali · Accepted solution]

Dear ,

Kindly find the attached workaround for your issue.

[Anonymous]

So you are after what is labelled Month 12 to show value for Month 11.

For what is labelled Month 11 do you wish to show Month 11 value or that of Month 10 ?

[#4]

Please find the attached Document

[tresesco]

Among many options, one:

If(Month=vMaxMonth, sum(total {<Month={"$(vPreMaxMonth)"}>}Data), sum(Data))

PFA

[jyothish8807]

Hi Tresesco

I did the same before, but in my case its giving 148 to all the months can you tell me why?

I used:

if(Month=max(Month), sum(Total{<Month={'$(=Max(Month)-1)'}>}Data), sum(Data))

In my case all the months are getting same value, how?

Regards

KC

[tresesco]

Because of 'Month=Max(Month)' section of the formula. While your dimension is Month, Max(Month) would be always the same month(that is there in the row) as in the rows. Hence, the Month=Max(Month) comes always true for all rows.

You could try:

if(Month=max(Total Month), sum(Total{<Month={'$(=Max(Month)-1)'}>}Data), sum(Data))

Hope that helps.

[jyothish8807]

Got it  , thanks a lot Tresesco

Regards

KC