Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am working with Set analysis to create some KPIs in a dashboard.
To understand it correctly I am still going with tests.
I have this KPI function:
Sum( aggr ( { $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} discoverydate))))'} >}
price, product_id, filter_date) )
I have a current selection, with one product_id and one merchant, thus I should have one product with one price.
As I go with this set analysis I expect that the Sum of the one record should be the price of that product.
But if I have no filter_date selection in the current selection, I get a higher value.
Only if I set the filter_date by myself in the selection the Sum equals one price.
Is the Set analysis wrong?
Not quite sure what your setting is, have a look at
Set Analysis in the Aggr function
Sum({ $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} discoverydate))))'} >}
aggr ( { $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} discoverydate))))'} >}
price, product_id, filter_date) )
Not quite sure what your setting is, have a look at
Set Analysis in the Aggr function
Sum({ $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} discoverydate))))'} >}
aggr ( { $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} discoverydate))))'} >}
price, product_id, filter_date) )
Ok, I tried with 2 Sets before, but there are more things to be right.
I thought because of the reduced data, that I don't need that much dimensions in the AGGR.
But if I leave out the filter_date as dimension, it doesn't find data. The matrix seemed to be calculated and then the data is cut out depending from the Set.
What I now have:
(Dunno why this editor puts it as table)
Sum( { $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} filter_date))))'}, calc_merchant | = {"OWN_CLIENT_DATA_FLAG"} >} |
aggr ( { $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} filter_date))))'}, calc_merchant | = {"OWN_CLIENT_DATA_FLAG"} >} |
price * selling_quantity, product_id, calc_merchant, filter_date) ) |
I need cals_merchant as dimension because otherwise there are empty values for selling_quantity and thus even with the cals_merchant set to "OWN_CLIENT..." (where I have values for the selling_quantity) the AGGR is build in a wrong way.
I think I am near 80% to get it.
Thx for the help.