Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have no problem with adding the below statement to a Chart but when I try to use it in the load statement. Here is the command I was wondering if anyone has any idea's:
median (aggr(sum({<AssetName= {"Product Name"}>}X),AcctNum))
You can try something like below.
Median(sum(IF(AssetName = [Product Name], X)))
Use a group by clause and group the records to the same level as you were trying with the AGGR function.
If that does not work properly. then do the SUM in the first load statement and then take the median in another load statement.
Hope that helps.
Regards,
Aadil
Use an IF statement instead of using set analysis. Set analysis will not work on load scripts.
So what would it look like. Can you provide me an example.
You can try something like below.
Median(sum(IF(AssetName = [Product Name], X)))
Use a group by clause and group the records to the same level as you were trying with the AGGR function.
If that does not work properly. then do the SUM in the first load statement and then take the median in another load statement.
Hope that helps.
Regards,
Aadil