Continuous Dimension axis - how to return just one axis label per month?

[#1]

Hello all.

I have a line graph with the dimension MonthName(full_date) and the expression median(LOS_IncLeave).

I need each month to appear on the X axis once, even if there isn’t an expression value for a particular month. I can get this working if I check Continuous for the dimension axis.

However, if I check Continuous for the dimension axis then I get more than one label per month.

If I uncheck Continuous for the dimension axis then I get one label per month but then the months without an expression value disappear.

Any suggestions?

I realise there are similar threads on the forum however none of them seem to work when I use MonthName(full_date).

Thanks in advance, Michael.

[#2]

Now working if I put 30 (average number of days per month) as the static step.

Seems a bit clunky so I’d be interested to hear if there’s a cleaner solution.

Thanks, M.

[swuehl]

Are you using a (master) calendar that contain all Monthname values or only values where you have expression values, too? If latter, creating a Master calendar might be first part of a solution, please search the forum for some already available solutions.

Then, check if  'suppress zero values' is activated, if so, uncheck. Suppress zero values will remove all lines where all expression values are zero.

Hope this helps,

Stefan

[swuehl]

Using a static step might help, but I have found the display depending on graph size. QV seems to automatically decide how many dimension values to show for a continuous axis, also depending on graph size. So there might be some issues coming up when you add more values or resize your graph.

[pennetzdorfer]

Hi,

did you manage to find a static step formula in the meantime?

I tried something like  =Day(MonthEnd(Date))  which returns the number of days for every month ... but no effect. Dimension values still depend on graph size.