Hi guys,
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. :)
Cheers,
Wilfred
Hello Wilfred,
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.
Regards,
Hi Javier,
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.
Tks,
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
kpi
Thank you for coming back to me.
Is there a possibility that I can create a static line in whatever way?
Or are there other tools offered by Infragistics which I can explore?
Would like to know my options.
Tks much,
As for including a 'line' in the charts we have the trendlines which are automatic and doesn't fit your scenario in my opinion.
Something that you can do is to implement your own javascript visualization and use the R+ DIY visualization to match it.
We have this blog post for R+ 3.0 in which a IgniteUI visualization control is used within R+.
This is an advanced and complex use of the tool, but with wide possibilities.
We will try to talk with the team to include this feature you asked for the next version, but I can't compromise with that right now.
Best regards