Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
does anyone know how to identify the first and last value in a sparkline? Obviously the object itself is written to enable the user to color it, but I'd like to put the first and last values represented as numbers adjacent to the sparkline on either side.
Here is my formula for my sparkline:
avg({1<L90Days={1}>} DataPoint)
In the sparkline the dimension I'm moving over is days.
Any help anyone can provide is greatly appreciated.
Cheers,
Jeff G
The following structure will give you the "last" point within the sparkline.
Avg ( {$< filing_date={"=(max(filing_date))"} >} total_assets )
That makes sense for the max, but the min is tricky. Each row has a different start point for computation. If you use min on the filing_date, then you get the first filing_date, not the the first filing_date for that dimension value. Any thoughts?
Hi,
may you post an example qvw with your problem?
Stefano.
I don't know if this is your problem, but look at my example ane the property "show value" of the expression.
C u,
Stefano.