The appearance of the graph below is close to my target....
BUT... the X axis is supposed to be continuous, and isn't. It is missing the zero value that is calculated for January 2017. Alternatively, the ugly graph below shows what happens when I select "use continuous scale". My January zero shows up as it should, but the bars are skinny to represent a single day of the month.
I have a derived field in my data load : ...Dual(Month($1), monthstart($1)) AS [_YearMonth] Tagged ('$axis', '$yearmonth', '$simplified', '$hidden')...
I think I need to expand the values to extend the entire span of the month, but I don't know an elegant way to do this. Does anyone know the proper method to fix this?