Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be just this
Dimension
None
Expression
Max(INTERVAL)
Min(INTERVAL)
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.
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
Try this
Ceil(
Interval(
Max(Aggr(max({<FLAG_END={1}>} LAST_DAY) - min({<FLAG_END={1}>} FIRST_DAY), CD_SLA)),'D'))
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
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.
Would you be able to share a sample to show what you have?
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.