Set analysyis

[nareshthavidishetty]

Hi,

My set analysis is not working.

Is my set analysis is right?

Logic: = Sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={"$(=date(12*(Year(max([Calendar Date])))-Year(max([Calendar Date])) +Month(max([Calendar Date]))-Month(max([Calendar Date]))"}>}[# Open])

Thanks..

[sunny_talwar]

What exactly are you trying to accomplish here?

[Calendar Date]={"$(=date(12*(Year(max([Calendar Date])))-Year(max([Calendar Date])) +Month(max([Calendar Date]))-Month(max([Calendar Date]))"}

[YoussefBelloum]

Hi,

you should evaluate this date part:

$(=date(12*(Year(max([Calendar Date])))-Year(max([Calendar Date])) +Month(max([Calendar Date]))-Month(max([Calendar Date]))

using Date#() and the format you used inside your expression.

[nareshthavidishetty]

Hi,

We need to show the data roll back to 12 months in bar chart using set analysis.

Thanks,

[jyothish8807]

For rolling 12 months, you try  like this:

Dimension: [Calendar Date]

sum(Aggr(rangesum(above(total sum({<[Month Abbr]=, Year=, [Quarter Name]=>}[# Open]),0,12),[Calendar Date]))

Br,

KC

[Anonymous]

There are a few examples for rolling periods, maybe they can help you.

Set Analysis for Rolling Periods

[sunny_talwar]

Roll back 12 months from today?

=Sum({$<[Month Abbr], Year, [Quarter Name], [Calendar Date] = {"$(='>=' & Date(AddYears(Today(), -1), 'DateFieldFormatHere') & '<=' & Date(Today(), 'DateFieldFormatHere'))"}>}[# Open])