Line Chart get x value from y expression

Hendrik_Schaefer — Sat, 16 Nov 2024 20:54:07 GMT

Hi Community,

i want to use a Line Chart to get a course of the number of Sales.

The x-axis are the months of each year since the year 2000.

The expression for y values looks like:

=SUM((Date(Date#([rentalstart],'DD.MM.YYYY'),'DD-MM-YYYY')<=Date(Date#(X_Value,'DD.MM.YYYY'),'DD-MM-YYYY')) AND (IsNull([rentalend]) OR Date(Date#([rentalend],'DD.MM.YYYY'),'DD-MM-YYYY') >= Date(Date#(X_Value,'DD.MM.YYYY'),'DD-MM-YYYY')))*-1

For the calculation on y-axis, i need the selected value on x-axis, that replaces the field X_Value in the expression.

Is there a Function or something like getCurrentXValue(), that i can call from the expression?

Re: Line Chart get x value from y expression

tresB — Fri, 10 May 2019 07:50:07 GMT

GetFieldSelections(X_Value)

topic Re: Line Chart get x value from y expression in App Development

Line Chart get x value from y expression

Re: Line Chart get x value from y expression