Char - (type range)

[shoshana.uzan]

Hi

I’m planning a bar char at eazybi
row: The name of the project
column: Release dates of project versions
page: time
Interested in drawing a vertical line for each project whose beginning and end will match the filter of the page
I thought using the range but I have no idea how I get the filter start date and end …
Is it possible to get the filter dates to measure?

This is the report:
(Interested in calculating the start date and end date from the page filer )

Regards
shoshi

[lauma.cirule]

Hi @shoshana.uzan,

You can get the start and end dates of the filtered time period with following formulas (formatted as dates):

• Start date
  [Time].CurrentHierarchyMember.StartDate
• End date
  [Time].CurrentHierarchyMember.NextStartDate

When added as lines and without symbols they will give the following vertical lines in the chart:

Lauma / support@eazybi.com