Hi,

From what I see on the chart, you have data only for 22-Apr-2016, so you will have only a single point for that day.

Maybe you have a date field on pivot rows, aggregating by day, or maybe drilled down the data to a 'day' scope.

I would suggest to use drill up to restore to monthly aggregation and see what happens.

Also you can tap the little grid icon to filp to a grid visualization in order to see which data is behind this chart.

It the issue persists, send me a screen capture of the grid data behind this chart.

I hope this can help :)

Best,

Hi Christian,

Did it.. can't get it to work too..

Is there anyway, I can just force a static line across?

@Wilfred

Hi Wilfred,

To use the solution that I recommended, we would need to have more points on the x axis, which is equivalent to having more rows on that grid. Otherwise you will see only a point instead of a line (as you saw).

Currently, we don't have a feature to generate this line.

Could you please send me a screen capture of the pivot table definition to see If we can figure out another alternative?

Best regards

Hi Christian,

Not sure if this is what you are looking for.

@Wilfred

Hi Wilfred,

Sorry for the delayed response.

We don't have a good workaround for this scenario.

As long you would have a single point on X axis, you will see a single point on the lines for this settings.

An alternative is to create a new row, with all 0 on the falues values for the next month, and chart that as usual.

The result would be something like this:

I hope this can help, but I know it's not the best solution.

Kind regards