Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear ,
I'm putting together a dashboard with a scatter plot that will represent a graph quadrants . To mount the quadrant graph have to put two reference lines dividing the graph in half on the x axis y . In the creation of the reference line box has the option to set the percentage of the same position but does not work correctly because I put in 50 % and the line appears near the zero point and not in the middle as expected . Can also be defined by expression but can not calculate what is the value that must be present at the time of presentation for not knowing how to get what maximum values of the axes ( x and y) being presented at the time on the chart.
My question is: how to get these values dynamically ?
=Max(the_expression_in the chart)/2 u used in the chart in the reference line
Dear Yusuf
The expression used was Sum ( Valor_X ) . When I use MAX ( Sum ( Valor_X ) ) / 2 gives syntax error. Not to give error have to use MAX ( TOTAL Sum ( Valor_X ) ) / 2. But this does not work because it does not position the bar on site. It does not appear.
Is getting the most value plotted in the graph to the axis of x and y axis ? some function that returns these values.
Emmanoel Gomes da Silva
Try this
Max(Aggr(Sum(Valor_X),Chart_Dimension))/2
Regards,
KKR