Im trying to get the avg shipping date for every productID and then in my chart I want the ProductID(Versand_Dat.IDENTNR) to be shown but there is always the date shown does anyone know why maybe Im handling the aggr function wrong I appriciate any help even the explanation of the aggr function from scratch
MT, your aggr() function is building an in-chart / inline table with dimension IDENTNR and an average VERSADAT as expression.
Not sure why you expect to see IDENTNR as outcome, or what you want to do with the VERSADAT then (or how you get to the IDENTNR from the avg VERSADAT).
Aggr is used to aggregate the expression included.
So what you do here is aggregating the avg over productid. For each product id, this function will return a date value. If you use it in a chart, you simply need the poduct id as a dimension, no aggr needed.
