Hello everyone,
I would like to make a graph where Dimension is a range.
Mock Up: I have got a table with an Object ID, a Gross Value and a numeric Attribute A1.
I would like to sum up the Gross Value if A1 is bigger than the Dimension and have a range with step of 5 as my graph dimension. The result would look something like the upper right quadrant of 1/x.
I tried creating a variable as range, but PQL gives me the error, that the temporary table is not connected.
Thanks in advance!
Not sure I quite understand the ask
Not sure I quite understand the ask
Hello Desislava and thank you for your reply.
I would like to visualize how our calculated prices will change depending on a threshold. The actual calculation logic is pretty complex, but for the mockup purposes it should suffice to use something simple.
I created an excel mockup to show what I mean.
Sum of GROSS_VALUE per dimension where A1 is >= dimension.
I hope I could make my ask somewhat clearer.
PU_SUM ( target_table, source_table.column [, filter_expression]> = dimension)
Calculates the sum of the specified source column for each element in the given target table.
PU_SUM ( target_table, source_table.column [, filter_expression]> = dimension)
Calculates the sum of the specified source column for each element in the given target table.
My main issue with that approach is, that I don't actually have a dimension. If I just use A1 as dimension, I will end up comparing every entry with itself and just get a sum per A1 variant. like this:
If I use some form of RANGE command to generate dimension - I get the error "the tables eTABLE1] and nTemporary table: RANGE] / Temporary table: GENERATE_RANGE] have no common table, since they are not connected".
My main issue with that approach is, that I don't actually have a dimension. If I just use A1 as dimension, I will end up comparing every entry with itself and just get a sum per A1 variant. like this:
If I use some form of RANGE command to generate dimension - I get the error "the tables TABLE1] and Temporary table: RANGE] / Temporary table: GENERATE_RANGE] have no common table, since they are not connected".
You can use BIND function to connect the 2 tables. PU functions also connect 2 no common tables
My main issue with that approach is, that I don't actually have a dimension. If I just use A1 as dimension, I will end up comparing every entry with itself and just get a sum per A1 variant. like this:
If I use some form of RANGE command to generate dimension - I get the error "the tables TABLE1] and Temporary table: RANGE] / Temporary table: GENERATE_RANGE] have no common table, since they are not connected".
However both PullUp and BIND require the tables to have at least an indirect connection, which is not the case with a temporary table.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
