Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am trying to show top10 and bottom10 sales values of customer in block chart.I tried to limit the dimension by dimension limit tab and showing largest 10 for top 10 and smallest 10 for bottom 10.The issue here I am facing is getting the correct value for top10.But for bottom I am not getting any data.The reason I can see is in my data there are certain values with negative numbers.
Is there any way we can show bottom 10 values?
Please let me know in case of any questions.
Regards,
Mayank
may be try with this expression instead of Dimension limit
=sum({<BlockChartDimesion={"= rank(sum(Amount),4)<=10"}> +<BlockChartDimesion={"= rank(-sum(Amount),4)<=10"}>}Amount)
They are 2 different charts 1 is for top 10 and 1 is for bottom 10.It will get enabled on button selection for top and botttom.
even I use the above expression ,I am getting error Positive andnegative vaues in the chart
can you post sample?
Hi Kushal,
Again back to the old issue.
Attached is the sample qvw.
Please let me know in case of any more information required.
Regards,
Mayank !