Interval in bar chart

[talita_verdes]

Good afternoon!

I have a problem and I can not solve.

I have the table below:

CD_SLA	FIRST_DAY	LAST_DAY	INTERVAL
21964	04/12/2014 10:07	10/01/2017 09:07	768
23296	26/02/2015 10:42	24/01/2017 08:39	698
31577	27/04/2016 18:48	05/01/2017 14:41	253
32363	14/06/2016 15:08	03/01/2017 11:34	203
32490	20/06/2016 13:00	04/01/2017 15:50	199
32896	13/07/2016 11:06	04/01/2017 15:49	176
33347	11/08/2016 13:54	30/01/2017 10:35	172
33431	16/08/2016 15:51	04/01/2017 15:49	141
35866	31/01/2017 14:59	31/01/2017 15:02	1

I need to display in a bar chart the maximum value of interval column and the minimum value.

The result would be:

Max: 768

Min: 1

How can i do it?

Thanks

[sunny_talwar]

May be just this

Dimension

None

Expression

Max(INTERVAL)

Min(INTERVAL)

[greend21]

You could try setting the Dimension Limits to show only smallest 1 value. Then select show others and maybe try max(INTERVAL). I never used the Show Others option but it seems like it should work.

[talita_verdes]

My problem is that the interval column is calculated with the following formula:

Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D'))

I already tried min, max, rangemin but it did not solve

[sunny_talwar]

Try this

Ceil(

Interval(

Max(Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA)),'D'))

[kaushiknsolanki]

Not sure but you can try this.

Max(Aggr(Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D')), CD_SLA))

Min(Aggr(Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D')), CD_SLA))

Regards,

Kaushik Solanki

[talita_verdes]

Sunny and Kaushik

I tried these expressions before, but It didn't work.

My bar char has monthName dimension  from master calendar.

I tried use on aggregation the field MonthName, but it didn't work too.

[sunny_talwar]

Would you be able to share a sample to show what you have?

[hjimenez25]

Hi,

Maybe you can try this:

Expression:

Max( TOTAL Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D'))

)

Min( TOTAL Ceil(

Interval(

Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA),'D'))

)

I hope this help you.