Min and Max for Liner Diagram

[Samanehsorournejad]

Hi every one,

I have liner Diagram and I want to plot the Min, Max Line for my Diagram. Is there any Person who could guide me? which Setting should I use?

Thanks in Advanced

[justISO · Accepted solution]

Hi, in your charts properties tab choose Add-ons -> Reference lines and add 2 reference lines, 1 as min, other as max:

[Samanehsorournejad]

thanks to answer, i had done the same configuration and for references line expression, I had write this formula but unfortunately it dose not work. 

max(aggr(count({$<allgemeintzeit_Date={">$(vFrom)<=$(vTo)"}>} id)", Hour(TimeStamp#(allgemeintzeit, 'DD.MM.YYYY hh:mm:ss')) "))

could you pls tell me why my measure does not work?

[justISO]

Maybe try without ' " '?

max(aggr(count({$<allgemeintzeit_Date={">$(vFrom)<=$(vTo)"}>} id), Hour(TimeStamp#(allgemeintzeit, 'DD.MM.YYYY hh:mm:ss')) ))

[Samanehsorournejad]

Hi again,

I had change my measure like this :

Hour(TimeStamp#(allgemeintzeit, 'DD.MM.YYYY hh:mm:ss')) as Stunde  --> in backend

=max (aggr(count({$<allgemeintzeit_Date={">$(vFrom)<=$(vTo)"}, art={"$(vArt)"}>} id), "Stunde" ))

it works but it shows me something like :

is there any one who could guide??