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

Popular posts from this blog

ruby - Trying to change last to "x"s to 23 -

jquery - Clone last and append item to closest class -

c - Unrecognised emulation mode: elf_i386 on MinGW32 -