calculated columns - Cross table in Spotfire -

-

*update based on ksp's answer (thank that, looking for.)

can me following problem.

given data table:

key     rec     period  dow    category value  key1    rec1    period1 dow1   kpia     x1     key1    rec2    period1 dow1   kpib     z1 key1    rec3    period2 dow1   kpia     y1   key2    rec4    period1 dow1   kpia     x1       key2    rec5    period1 dow1   kpib     z1 key2    rec6    period2 dow1   kpia     y1   key1    rec7    period1 dow2   kpia     x2       key1    rec8    period1 dow2   kpib     z2 key1    rec9    period2 dow2   kpia     y2   key2    rec10   period1 dow2   kpia     x2       key2    rec11   period1 dow2   kpib     z2 key2    rec12   period2 dow2   kpia     y2 key1    rec13   period1 dow1   delta    d1 key1    rec14   period1 dow2   delta    d2 key2    rec15   period1 dow1   delta    d3 key2    rec16   period1 dow2   delta    d4

in spotfire, possible create following cross table:

              avg(kpia)          avg(kpib)      delta          period1     period2      period1       period1                         dow1 dow2   dow1 dow2    dow1 dow2     dow1  dow2        key1    x1   x2     y1   y2      z1   z2      d1    d2 key2    x1          y1   y2      z1   z2      d3    d4

now there want change in cross table can’t manage figure out how:

delta column valid period1. possible apply period , dow level columns of cross table?

so want is: 

              avg(kpia)          avg(kpib)       delta          period1     period2      period1                 dow1 dow2   dow1 dow2    dow1 dow2     key1    x1   x2     y1   y2      z1   z2      (d1 + d2) / 2  key2    x1          y1   y2      z1   z2      (d3 + d4) / 2

and when dow2 filtered out:

              avg(kpia)         avg(kpib)        delta          period1     period2      period1                   dow1        dow1         dow1      key1      x1          y1           z1             d1 key2      x1          y1           z1             d3

thanks in advance.

@ user6076025 - please check solution , let me know if helps.

i have considered x 1, y 2 , z 3 computation purpose.

i have unpivoted data there in first screenshot of post , created cross table unpivoted data.

attached screenshots reference.

unpivot data

cross table unpivoted data


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

reactjs - React router and this.props.children - how to pass state to this.props.children -

-
i'm using react-router first time , don't know how think in yet. here's how i'm loading components in nested routes. entry point .js reactdom.render( <router history={hashhistory} > <route path="/" component={app}> <route path="models" component={content}> </route> </router>, document.getelementbyid('app') ); app.js render: function() { return ( <div> <header /> {this.props.children} </div> ); } so child of app content component sent in. i'm using flux , app.js has state , listens changes, don't know how pass state down this.props.children. before using react-router app.js defines children explicitly, passing state natural don't see how now. using couple of react helper methods can add state, props , whatever else this.props.children render: function() { var children = react.ch...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more