Nilanjan Saha 3 Posted July 9, 2020 Share Posted July 9, 2020 Hi I have a table which i need to show the data in a specific format.I have attached the dxp for any help. Please can anybody help on how to acheive the feature in Spotfire! Link to comment Share on other sites More sharing options...
Nilanjan Saha 3 Posted July 9, 2020 Author Share Posted July 9, 2020 Link to comment Share on other sites More sharing options...
Fabian Duerr Posted July 10, 2020 Share Posted July 10, 2020 Maybe this will not be the final solution, but it get's close... 1st unpivot your table and then do a pivot again. Use the 'add data table' option with transformation Or you only use the unpivot transformation and than visualize your data with a cross table: Link to comment Share on other sites More sharing options...
Gaia Paolini Posted July 13, 2020 Share Posted July 13, 2020 if you have TERR you could do it with a small data function, with your KPI table as input (dt1) and a new table as output (dt2) like this dt2=as.data.frame(t(dt)) dt2$rowID=colnames(dt) Link to comment Share on other sites More sharing options...
Nilanjan Saha 3 Posted July 26, 2020 Author Share Posted July 26, 2020 Thanks a lot Gaia for your help...this worked! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now