Calculated Dimension

[wesleyschut]

I have a bar chart with forecast information. The dimension is Year Month.

The users can select a Year and a Month from the selection boxes.

Now when a user selects 2020 Feb I would like my bar chart  to show the selected YearMonth and three months in advance.

How can i modify the dimension that the chart will show Feb to May?

Regards,

W

[martinpohl]

here's an example:

Sum({<Date={">=$(=date(min(YearMonth)))<=$(=date(monthend(addmonths(min(YearMonth),3))))"}, YearMonth>} FC)

Date is the field in your datas.

YearMonth is a field from your calendar.

if the user can select Year and Month change to

Sum({<Date={">=$(=date(min(YearMonth)))<=$(=date(monthend(addmonths(min(YearMonth),3))))"}, Year,Month>} FC)

use it in expression, YearMonth as dimension

regards

[Brett_Bleess]

Wesley, did Martin's post get you what you needed?  If so, please be sure to properly close out the thread by using the Accept as Solution button on Martin's post to mark it, this also gives him credit for the assistance and lets other Members know it did work.  If you did something different, you can post that and mark it, but it is appreciated if you do close things out.

Regards,
Brett