Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
emyemyemy
Contributor III
Contributor III

Add horizontal line with expression or reference line in chart

Hello ,

I have table 1 and table2 bellow :


tale1 :

LOAD  week
workshop,
numSUM(defaut1,defaut2) as sumDefaut

FROM
[path]
(
ooxml, embedded labels, table is sheet1)
;
table2:
LOAD ,
workshop,
limit
FROM
[path]
(
ooxml, embedded labels, table is sheet2) ;

my chart line is created from  table1 :

Dimension1 = week

Dimension 2 = workshop

expression1  = if ( workshop = inputText  , sum(sumDefaut))

until this level every thing is working very well .

Now I want  to add  horizontal line refer to avg(limit) in my chart  using  add new expression2  with condition used in dimension :   if(workshop = inputText, avg(Limit))

result : first expression1 disappear  and the new  exp2 appear ( horizontal line)  ,

I tired with adding  reference line : if (workshop = inputText, avg(Limit)) also I tried it with Constant   but nothing shows .

I wish this is clear  , I'll be grateful for any help and attention


1 Solution

Accepted Solutions
emyemyemy
Contributor III
Contributor III
Author

Hello ,

I   changed  chart type  from chart line to Combo chart .

Both expressions shows  .

View solution in original post

1 Reply
emyemyemy
Contributor III
Contributor III
Author

Hello ,

I   changed  chart type  from chart line to Combo chart .

Both expressions shows  .