Max and Min in same expression

[sivarajs]

Hi,

I have a chart which values from low to high.The x axis has around 150 values so we reduced the size of chart. Because of that it showing first few values. Is there a way we can show min and max in same expression in between few values?

Regards,

Sivaraj

[robert_mika]

Could you post an example?

[sivarajs]

PFA's

[robert_mika]

Try the attached

[sivarajs]

how to achieve in same expression?

[robert_mika]

Could you elaborate?

[sivarajs]

The chart size what i have need not be changed. Because am displaying more number of chart in a sheet.

If you add more than a expression the legend will go (second dimension). I need to show those as well.

My question is, how to show max and min in same expression which i have used?

[gandalfgray]

As I understand you, you want to see the chart values only for the min and max DATE in current selection.

If so, use this in the chart expression:

sum({<DATE={'$(=Date(min(DATE),'YYYY-MM-DD'))','$(=Date(max(DATE),'YYYY-MM-DD'))'}>}[Response Time])

(You should probably change the YYYY-MM-DD to fit your date format)

[tresB]

Use calculated dimension, like:

=If(DATE=$(=Max(DATE)) Or DATE=$(=Min(DATE)), DATE)

PFA

[sivarajs]

Max and Min is works fine. Can't we show trend between max and min? means some values in between.