10 Replies Latest reply on May 7, 2018 2:31 PM by Deepak Rai

# Is it possible to create 3 line graphs using 3 Measures?

Hello,

Hopefully this is simple which I seem to can't get my head wrapped around.

I have a requirement, where the user would like to see 3 measures.

• There is a date field "Event Date" and a Measure "Total (expense) Incurred".
• User would like to see a line for each of the following, for which I have created a calculated field for each
• Current Year - YTD
• Prior Year - Full prior calendar year
• Last 5 Years

This is how I have it currently, but I would like all 3 in a single view (something like dual axis but all 3). I tried to convince the user with combination of bar graphs with reference line but user insisted on 3 line graphs. As you can see in the screenshot, Current Year starts from the end of Prior Year while I want to match with YOY comparison.

Appreciate any suggestions, workarounds.

Thank you,

Shiva Ram.

• ###### 1. Re: Is it possible to create 3 line graphs using 3 Measures?

Will This Work?

1 of 1 people found this helpful
• ###### 2. Re: Is it possible to create 3 line graphs using 3 Measures?

What about this?

1 of 1 people found this helpful
• ###### 3. Re: Is it possible to create 3 line graphs using 3 Measures?

Deepak, quick reply as always. Yes, something like this would work if I can convince the user. After I posted the question, I created a similar chart which looks like this,

Notice the break between lines, would be clean to get rid of it.

This is the calc I have,

STR(IF YEAR([Event Date]) = YEAR(TODAY()) THEN 1 ELSEIF YEAR([Event Date]) = YEAR(TODAY())-1 THEN 2 ELSEIF YEAR([Event Date]) > YEAR(TODAY())-5 THEN 3 END)

Thank you,

Shiva.

• ###### 4. Re: Is it possible to create 3 line graphs using 3 Measures?

That looks Fine!!

• ###### 5. Re: Is it possible to create 3 line graphs using 3 Measures?

But mine doesn't look continuous like the one you posted (notice the breaks between lines). You know why?

• ###### 6. Re: Is it possible to create 3 line graphs using 3 Measures?

You want Breaks???

• ###### 7. Re: Is it possible to create 3 line graphs using 3 Measures?

No. I want one continuous line while switching colors. Is it possible?

• ###### 8. Re: Is it possible to create 3 line graphs using 3 Measures?

I showed you that in screenshot

• ###### 9. Re: Is it possible to create 3 line graphs using 3 Measures?

Ah! Sorry, overlooked it. Got it fixed now.

Thank you so much Deepak.

• ###### 10. Re: Is it possible to create 3 line graphs using 3 Measures?

Welcome