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

Capture and play voice with Asterisk ARI -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

visual studio - Installing Packages through Nuget - "Central Directory corrupt" -