How to show the Current Year and Next Year together in x-axis

Questions & Answers
1

Hi guys,

I want to have the current year and next year together in x-axis in my report.

For example, I was able to show the Current Year by using “Time” filter in Pages : Current year.

So it shows only Jan 2024 ~ Dec 2024.

Now the following is what I want to have:

11111111111111111
111111111111111111564×502 25.9 KB

2

Hey @Kyung_Park ,

I have set up a similar report. In the Time Dimension I established a Current year, Previous year and Next year Calculated member. Selecting these then separate each period along the X-Axis.

That seemed to do the trick for me.

Hope this helps

Dave

1 Like
3

Hi @David_Horne ,

How can I make Next Year Calculated Member?

Also, can you provide the actual formula or report you have?

4

HI @Kyung_Park

The Next year calculated member formula I did was:
Aggregate({
[time].[year].CurrentDateMember.NextMember
})

5

Thanks, @David_Horne ,

One more question.

Is it possible to display both the current year and next year in a single report, without separating them into two distinct periods?

6

Do you mean as in a bar graph report?

7

Yes, I’d like to see Jan 2024 - Dec 2025 in one bar graph.

8

You could try a Between dates Calculated member.

Aggregate(
[Time].[Month].datemembersbetween(“1 January 2024”, “31 December 2025”)

Cheers

Dave

9

@David_Horne
Thank you for providing this, but it shouldn’t be a specific date/year like “1 January 2024” or “31 December 2025” since it should be automated system every year.

I understand that
The Current Year: Aggregate({[time].[year].CurrentDateMember})
The Next Year: Aggregate({[time].[year].CurrentDateMember.NextMember})

But I’m not sure how to display both current year and next year in one bar graph using the syntax, not specific ranges.

10

The way I have done it is as follows:

Project Dimension as Page

Issue and Time Dimension in Rows

In the Time Dimension select your current, previous and next year calculated measures.

Then select the project/s you want to display.

Make it a Bar report.

Also select the measures you want to display i.e. Issues created, issues resolved, etc

Cheers

Dave

11

@David_Horne

Thank you for the details!

So Would it be possible to display the previous, current, and next years in your single report?

If you don’t mind, could you provide a snapshot of that?

12

@David_Horne
Hey David, I could finally find the way to display the current year and next year in one report.
I defined a new calculated member using the following formula:

Aggregate({
[Time].[Year].CurrentDateMember,
[Time].[Year].CurrentDateMember.NextMember
})

Thank you for your help!

2 Likes
13

@Kyung_Park great news. :slight_smile:

1 Like