Anyone knows how to add a KPI into my created chart (without having to add another data to the excel worksheet?)
Any help is well appreciated. :)
Thank you for posting at IG Forums!
It looks like you're trying to add a calculated column? Is this correct?
You can add new calculated fields but the values it uses must be fixed or result of a formula.
Let me know if I'm heading in the right direction.
I am revisiting this thread...
Don't know if you could see my uploaded image.
another link: http://tinypic.com/r/t8966w/9
Have a look pls.
Could you tell us how do you have this KPI value?
Is it a certain field?
From what I see and trying to reach what you expected, I would suggest:
(Assuming that you have your KPI data in a separate field or a new calculated field as Javier suggested before)
I hope this might help for your case.
Hi there, I tried the method.
But I got a DOT (orange in colour) instead of a line...
Do apologise if my response is so late. will follow up tightly next time.
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 :)
Did it.. can't get it to work too..
Is there anyway, I can just force a static line across?
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?
Not sure if this is what you are looking for.