Webi Chart formatting for data points

[Former Member]

Is there a way to have a webi chart just show the final (most recent) data point?  I have attached a picture of what I am trying to do.  I would also like to be able to put in a variable at the top to show the % of Total automatically on refresh.

Webi 4.1 SP2 Patch10

Thanks in Advance for any assistance.

Jen

[mhmohammed]

Hi Jennifer,

Create 2 variables and use the v_Max Data Point to display in the Chart.

v_Recent Date

=Max([Date]) In Block

v_Max Data Point

=If([Date]=[v_Recent Date]) Then [Data Point]

You can use the Chart Title/Header by writing a formula to display the Total Automatically.

Thanks,
Mahboob Mohammed

[Former Member]

Thank you Mahboob!  I am going to give this a try right now.