Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks a lot Jyothish...it worked for me..