Cristian Tibrea Posted August 23, 2023 Share Posted August 23, 2023 Hello, I would like to create a small text area where I need to put the numbers that will update everyday. I know it works with datetime, but when trying to choose decimal numbers it asks me for an aggregation, which I don't need. Is there a trick to get that done? This is the Text area where data should populate and this is the values that should get there: SUM_DEPTH for Interval Drilled ..., and MAX_DEPTH for Hole DepthAny suggestion is valuable. Thank you Link to comment Share on other sites More sharing options...
David Beagan 2 Posted August 24, 2023 Share Posted August 24, 2023 You have this tagged as both a Spotfire question and WebFOCUS question. It can only be one of those. Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted August 24, 2023 Share Posted August 24, 2023 Agreed. The screenshot indicates that this is about Spotfire so I have removed the WebFOCUS topic/tag. Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted August 24, 2023 Share Posted August 24, 2023 Hello Christian,Could you please explain what you do in more detail (step by step) and ideally include a sample dxp file that illustrates your issue?In general though, if you are e.g. inserting a Calculated Value, that single value would be calculated using all rows in your selected data table, and thus need some kind of aggregation to become a single value. For cases when you as the author know that there is no actual value to the aggregation (i.e. you know that there will always only be a single row of data, or the values in each row are the same), you simply pick an aggregation anyway that returns the same value as the unaggregated value (e.g. the "First" aggregation, which I assume should be a very quick operation)Best RegardsFredrik Link to comment Share on other sites More sharing options...
Cristian Tibrea Posted August 24, 2023 Author Share Posted August 24, 2023 Hi Fredrik, the SUM_DEPTH come from an aggregated query (is already SUM), that's why I just wanted to display the value in the cell. Adding another aggregation is not doing any good. Regards Link to comment Share on other sites More sharing options...
Kirsten Smith (she/her) Posted August 24, 2023 Share Posted August 24, 2023 Usually in cases like this you can use First() as the aggregation to get past that requirement Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted August 25, 2023 Share Posted August 25, 2023 Hello Christian (and Happy Friday!),There are a number of operations in Spotfire where aggregation is required (and those are not aware of/can't assume that your data will always remain "pre-aggregated" even if that happens to be the case right now). As both Kirsten and I have previously suggested, in cases like that, simply pick an aggregation. If I just want any value, I usually go with First() - in your case, if you could actually end up having multiple values at some point, maybe Sum() would be suitable (it all depends on your use case). Link to comment Share on other sites More sharing options...
Cristian Tibrea Posted August 29, 2023 Author Share Posted August 29, 2023 Hi Kirsten, Fredrik and all. I don't have that option on my case (see screenshot), maybe is the Snowflake I am connected to, not sure. Is just Min, Max. Max works for Hole Depth, but for the SUM_DEPTH can't find yet the solution. Much appreciate your responses. Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted August 29, 2023 Share Posted August 29, 2023 Hello again! If you are using Snowflake in-database (and want to continue using that - not importing the data into Spotfire, where all Spotfire functions become available), you are limited to certain functions (as described in the manual: https://docs.tibco.com/pub/sfire-analyst/12.5.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connectors%2Fsnowflake%2Fsnowflake_supported_functions.htm&rhsearch=snowflake&rhhlterm=snowflake&rhsyns=%20)What is the most suitable function is for you to decide (in case there could ever be multiple values), but Sum or Avg could be good candidates.Best RegardsFredrik Link to comment Share on other sites More sharing options...
Cristian Tibrea Posted August 29, 2023 Author Share Posted August 29, 2023 Thank you Fredrik, yes, Snowflake is the only option, so we have to deal with that, I am using different visual for that. Regards 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