Max and Min Values on Data points

[#1]

Hi All,

I have a querry.i am using a line chart with product and the below expression for month as dimension

and i am using sum(volume) as expression.

=Dual(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week), Week)

By using this expression the dimension label will be month were as the data points will be for weeks.as below graph.

here in the above graph,for each month you can see 4 or 5 data points ie. for each weeks.

Now i want to show values on data points only for the max week and the min week. Any idea how it can be achieved.

Regards,

Reena

[amit_saini]

Hi,

See the attachment.

Thanks,

AS

[amit_saini]

you need to work here:

Thanks,

AS

[jyothish8807]

Hi Reena,

try like this:

create two variable:

vMaxWeek=max(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week))

vMinWeek=min(Aggr(NODISTINCT If(Week=Max(total <Month> Week), Month, ''), Month, Week)))

Now in chart, press + sign on expression.

go to show value:

=if(Week = '$(vMaxWeek)' or Week = '$(vMinWeek)' ,1,0)

Hope it helps.

Regards

KC

[jagan]

Hi,

Try like this

Expand + symbol of the expression and give this expression in Show Value option

=Dual(Aggr(NODISTINCT If(Week=Max(total <Month> Week) OR Week=Min(total <Month> Week) , Week), Month, Week), Week)

[Anonymous]

Never noticed that Show Value option before, could be useful.

[jyothish8807]

[amit_saini]

[tresesco]

Try expression (at Show Value property as shown above):

Aggr(NODISTINCT If(Week=Max(total <Month> Week), 1, 0), Month, Week) Or Aggr(NODISTINCT If(Week=Min(total <Month> Week), 1, 0), Month, Week)

[jyothish8807 · Accepted solution]

Hi Reena,

Try like this:

Create a new expression and disable line and symbol option and enable only value at data point.

If(WeekEndingDate_1=Max(total <ProductFranchise_13> WeekEndingDate_1),Sum([Volume TRx]), If(WeekEndingDate_1=min(total <ProductFranchise_13> WeekEndingDate_1), Sum([Volume TRx]),''))

Hope it works

Regards

KC