topic Min and Max for Liner Diagram in App Development

Min and Max for Liner Diagram

Samanehsorournejad — Mon, 10 Oct 2022 07:15:06 GMT

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 — Mon, 10 Oct 2022 08:21:32 GMT

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

Samanehsorournejad — Mon, 10 Oct 2022 08:38:00 GMT

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 — Mon, 10 Oct 2022 08:42:16 GMT

Maybe try without ' " '?

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

Samanehsorournejad — Mon, 10 Oct 2022 09:32:50 GMT

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??