tibco - How to access Spotfire expression values using IronPython script -
i'm trying results of expressions in spotfire 7, i.e., same values shown in visualisations, using ironpython script.
consider following data:
+----+------------+-------+ | id | date | value | +----+------------+-------+ | 1 | 2016-01-01 | 5 | | 2 | 2016-01-21 | 6 | | 3 | 2016-02-01 | 4 | +----+------------+-------+
we create scatter plot <binbydatetime([date],'year.month',1)>
on x , avg([value])
on y axis, showing 5.5
2016-jan
, 4
2016-feb
.
how these values in ironpython? of course, loop on rows , aggregate result using dictionary. i'd rather use spotfire's code calculation. i'd prefer not need intermediate visualisation either, retrieve calculated values directly.
tibco documentation shows there's columnexpression
class used represent expressions. there spotfire.dxp.application.calculations
namespace, can't find mention of expressions there.
Comments
Post a Comment