I could not find an answer to this in other posts and figured a work around.
My problem was how to produce a chart that showed daily inventory levels over a 6 month time frame. I have daily data points that show the daily balance. When I put together a chart with the Inventory Balance as the Y axis and the Date Variable [Load Balance Datetime]. And NO, I did not build the universe, so someone else is to blame for the field name.
But, when I displayed the graph, every date appeared on the X axis.
What I wanted was to have the Month/YR appear at the first of the month.
Work Arround - I created a variable that only took a value on the first day of a month.
VMoYr =If(DayNumberOfMonth([Load Balance Datetime])=1;MonthNumberOfYear([Load Balance Datetime])+" “+FormatNumber(Year([Load Balance Datetime]);”####");"" )
I then pulled the VMoYr onto the X axis of my chart.
Here’s where the tricky part come in. I needed to make the value for [Load Balance Datetime] disappear but still have the data point appear on my chart. To do that, I clicked “edit report” - Properties - then scroll down to X-Axis - click Values twistie - Click "number for’ property and hover your cursor over the right side of the property box - until the grey box with the ‘…’ appears (Kinda like something out of Harry Potter)
Click the … and the Number format dialog box appears.
Click on Custom and in the Undefined box - on the lower right -
I entered a single “-” and then clicked the OK button.
(The custom box showed ;- for some reason) But it made the daily date disappear and only my vMoYr label appeared on the first day of the month.
Hope this helps others and Thanks BOB!
YOur board and members are a real life saver.
rtwolfe (BOB member since 2006-04-14)
(BOB member since 2009-09-14)