Lauren Posted June 6 Share Posted June 6 My cross table shows Sum(hours) (values) by site (rows) per pay period (columns). The rows have a site hierarchy (business > organization > site) and the columns have a date hierarchy (year > quarter > month > day). I am trying to apply color formatting with an upper control limit (UCL) and a lower control limit (LCL) based on the ROW UCL and LCL, but the formatting is applying based on the TABLE UCL and LCL. I created calculated columns in my data table that have Site UCL, Site LCL, and Site Average and that worked but I still couldn't get the formatting to work. How can I get Spotfire to apply color formatting based on the row values instead of the table values? Link to comment Share on other sites More sharing options...
Solution Kirsten Smith (she/her) Posted June 6 Solution Share Posted June 6 Make sure you are creating the "new" grouping to apply colors based on those ranges: Link to comment Share on other sites More sharing options...
Lauren Posted June 6 Author Share Posted June 6 That's what I've got here, not sure how to group it other than the default it gives me which is just Hours. It is still only highlighting in Green items above the TABLE average and yellow items below the TABLE average, I would like it to be the ROW average instead. Link to comment Share on other sites More sharing options...
Lauren Posted June 6 Author Share Posted June 6 I am creating this dashboard from a Tableau dashboard that I had already made, and for the KPI on that one I used WINDOW_STDEV. Not sure what the equivalent would be in Spotfire. Link to comment Share on other sites More sharing options...
Lauren Posted June 6 Author Share Posted June 6 Also adding, it does not give me the option to select Site Hierarchy for the color by. Link to comment Share on other sites More sharing options...
Lauren Posted June 6 Author Share Posted June 6 When I switch from Site Hierarchy to Site, it is allowing the grouping. But with Site Hierarchy, it does not. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted June 7 Share Posted June 7 Lauren, Can you share an example dxp file so we can have a better look at your challenge? Kind regards, David Link to comment Share on other sites More sharing options...
Lauren Posted June 7 Author Share Posted June 7 Unfortunately not since it has proprietary information in it. However it looks like I was able to resolve it by using the Site column instead of my Site Hierarchy. I'm not sure why this is the case. Maybe field type? Link to comment Share on other sites More sharing options...
Lauren Posted June 21 Author Share Posted June 21 It turned out that the problem was that I couldn't color my rows because I was using a hierarchy as my row column. When I switched to using a string column at the lowest level of the hierarchy, it let me color the rows like Kirsten's picture. 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