Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to have a line chart for some Amount with respect to Calendar year based on one dimension I'm able to do so but as a output chart it is showing me only 1 year dots instead of a complete line for different years; no filters applied to list box to any of the sheets.
Y >> Amount
X >> Calendar years
Third >> other dimension
Thanks..please let me know if i need to post some more info.
hi Achal,
Can you post ur sample qvw file so that I can have a check.
Regards,
Raghav
You have to add second dimension
ex if you want to show location wise yearly collection then
use year as first dimension, location as second dimension
and write expression as sum(amount)
this way you will get year on x-axis sum(amount) on y-axis (left side) and location as legends at right side.
if you change the order of dimension then
you get location on x-axis and year as legend at right side.
Thanks Shubhasheesh ,
I did that already but my issue is that I'm not able to see a cont. line connecting diff year it shows me only for one year in chart even though it got value for diff years.
Thanks Raghav, I can not send you d orig. one due to some restrictions but i'm just adding a sample file which got the same problem it got atleast 2 years but my original file showing me only for one year.
pls note m utilizing rank function.
Hi Achal,
I could see that the rank function which u have put is not returning the values for all / two years and hence the issue.
Regards,
Raghav
Probably.
any idea how to rectify, as I can not only plot rank i need to show rev vs year based on third P dimension.
do I need to put anything for year as well in my expression for the rank to work perfectly as desired?