Sparkline Report by defined dates

Questions & Answers
,
1

Hey team,

I am trying to build a summary report that I can snip and share to a number of external reports. Sparkline reports seem to be favoured, but I want to define the time period as defined dates i.e. Increment One is 19 January 2026 to 10 April 2026.

I currently use the following:

SparkLineData(

LastPeriods(

3,

[time].[month].CurrentDateMember

),

[measures].[Issues Due Count]

This dhows the three months but that’s not exactly in our Increment Period, is there a means to achieve this?

Cheers

Dave

2

Hi @David_Horne

Thanks for posting your question!

Try the expression below and see if it works for you

SparklineData(
  [Time].[Month].DateMembersBetween('2026-01-19', '2026-04-10'),
  [Measures].[Issues Due Count]
)

Best,

Elita from support@eazybi.com

1 Like
3

Brilliant, thanks so much for the assistance.

Have a tops weekend. :wink:

Cheers

Dave

1 Like