# How to set a 'goal' line in a chart

**URL:** <https://community.eazybi.com/t/how-to-set-a-goal-line-in-a-chart/412>\
**Category:** Questions & Answers\
**Created:** [March 22, 2018, 1:00pm UTC](https://community.eazybi.com/t/how-to-set-a-goal-line-in-a-chart/412 "2018-03-22T13:00:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![arama\_mihai](https://community.eazybi.com/user_avatar/community.eazybi.com/arama_mihai/32/184_2.png) [@arama\_mihai](https://community.eazybi.com/u/arama_mihai)\
**Post date:** [March 22, 2018, 1:00pm UTC](https://community.eazybi.com/t/how-to-set-a-goal-line-in-a-chart/412/1 "2018-03-22T13:00:30Z")

</div>

Hello,

I have a chart that shows the average days for some issues, over a period of time, by a field called ‘Severity’.

This is what it looks like:

 ![image](https://community.eazybi.com/uploads/default/original/1X/356afe6e844f06ae7c9bd67547426f9931c9aa7c.png)

So currently I have “Time” on rows, “Severity” on columns, and two other fields on pages.

What I would also like to add is a line for each severity, showing the ideal, or the goal for each one:

 ![image](https://community.eazybi.com/uploads/default/original/1X/15fa6e4441eb91026a7077985e64575c8ecb4568.png)

I hope this image is clear enough to show what I would like to achieve.

PS - the goal does not change, it is already known, for example, Severity ‘S’ will always be 2.

Thank you!

---

<div class="post-metadata">

**Author:** ![arama\_mihai](https://community.eazybi.com/user_avatar/community.eazybi.com/arama_mihai/32/184_2.png) [@arama\_mihai](https://community.eazybi.com/u/arama_mihai)\
**Post date:** [March 26, 2018, 12:19pm UTC](https://community.eazybi.com/t/how-to-set-a-goal-line-in-a-chart/412/2 "2018-03-26T12:19:15Z")

</div>

I figured out a way to do this:

I created a calculated member on measures that gives a value based on Severity. For example, all issues with S severity will get 2.

Then I simply added this to the report and made sure to choose it as a line type instead of bar.

---

<div class="post-metadata">

**Author:** ![Nuria](https://community.eazybi.com/letter_avatar_proxy/v4/letter/n/ed8c4c/32.png) [@Nuria](https://community.eazybi.com/u/Nuria)\
**Post date:** [October 22, 2018, 8:08am UTC](https://community.eazybi.com/t/how-to-set-a-goal-line-in-a-chart/412/3 "2018-10-22T08:08:16Z")

</div>

Hi Arama,

I am exactly looking to do that. Could you please help me defining the formula?  
In my case my team has the goal resolve issues in less than 4 days. I wrote:

[Measures].[Average resolution days]=4  
But it gives me as a result “false”.

How did you define yours?

---

<div class="post-metadata">

**Author:** ![arama\_mihai](https://community.eazybi.com/user_avatar/community.eazybi.com/arama_mihai/32/184_2.png) [@arama\_mihai](https://community.eazybi.com/u/arama_mihai)\
**Post date:** [October 22, 2018, 1:55pm UTC](https://community.eazybi.com/t/how-to-set-a-goal-line-in-a-chart/412/4 "2018-10-22T13:55:23Z")

</div>

Hello @Nuria

My formula looks like this:

CASE  
WHEN [Priority].CurrentMember.Name = ‘Blocker’  
THEN 2  
WHEN [Priority].CurrentMember.Name = ‘Critical’  
THEN 5  
WHEN [Priority].CurrentMember.Name = ‘Major’  
Then 10  
When [Priority].CurrentMember.Name = ‘Minor’  
Then 20  
ELSE 30  
END

Hope this helps.

For your case, it could be something similar to:

CASE  
WHEN [Measures].[Average resolution days].CurrentMember.Name \< ‘4’  
THEN 2  
END

This is not tested.