Add horizontal line with expression or reference line in chart

[emyemyemy]

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

[emyemyemy · Accepted solution]

Hello ,

I   changed  chart type  from chart line to Combo chart .

Both expressions shows  .