It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is it possible to make one of the lines in an eazyBI line Chart stop at todays date?

I want to have 1 of my lines on my line chart stop at the current date while all of the other lines continue through the end of my filtered date on the chart. Does anyone know of a way to make a line in eazyBI do this?

 

2 answers

1 accepted

0 votes
Answer accepted

Hi Alexis!

It would be possible to create a new calculated member that compares if the Time we are currently looking is before Now and only then return the measure value. 

Please see the following example for calculated member that shows Open issues only until today 

CASE 
  WHEN DateCompare(
    [Time].CurrentHierarchyMember.StartDate, Now()) <= 0
  THEN Val([Measures].[Open issues])
  WHEN [Time].CurrentHierarchyMember IS [Time].DefaultMember
  THEN Val([Measures].[Open issues])
END

Let me know if you have additional questions!
Lauma / support@eazybi.com 

Hey Lauma,

Thank you very much for your help that is what I needed!

Alexis

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Teamwork

Listening out loud: how Dave Liao works on distributed teams

The start of the COVID-19 pandemic served as a forcing function to re-evaluate the way teams worked together. In fact, many companies are re-learning how to collaborate with their teams. As some move...

112 views 4 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you