Limit line graph to every 15 days

[#1]

Is there a way to limit the x axis values to every 15 or so data points. I have a graph that shows every day of the year, but the graph would be two wide to show the whole year. Is there a way to do this in the graph settings. Or do I have modify my dimension?

Thanks,

Alex

[swuehl]

If you want to complete get rid of the year information (which the date() function will still keep),

try

num(month(D),'00')&num(day(D),'00') as DateMMDD,

[#3]

What do you mean draw both years on the axis? I only want to see 1 line, comparing CY numbers to LY's.

I tried the below calculation and I get a flat line.

[#4]

Scratch that, I had to change to the correct date. It looks like this will work, but I need to verify. Thanks for the help!

[#5]

Okay, so I thought I had it, this where I am now. I'm back to get the numbers on the x-axis. Any ideas for me? This happens only when I click continous in the axis menu.

[swuehl · Accepted solution]

Have you tried disabling the continuous axis, enabling the "show all bars" option lik described above?

[#7]

Boom, that did it. Thanks swuehl!

[#8]

So, one more tweak would be great. Is there a way to show every 15 or 20 days? That way the graph is little less cramped. I just know the customer will ask for this.

[swuehl]

If you are not using continuous axis, the axis static options are disabled (and QV seems don't really care about them anyway). So QV will decide which and how many axis labels to show depending on label orientation, font size etc.

No, I don't think you can really force QV to show every 15 or 20 days.

You can try to generate a new dimension with dates in that period, and average the values within the period, or just use the value at your sampling point date.

[#10]

Gotcha. It looks like the way I have it setup currently will work for the client. Thanks for the explanation.

[perumal_41]

Hi Alex ,

I am also facing Same problem .if possible sample application upload for my reference.

Regards

Perumal A