Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a mistery problem in a pivot table
The formulas are the same as the field names, and when I try to use "min(requesttime)" it throw an error. I think that the result of this dimension must to be at least the same of the previous column (later I will try to get the real min of each key)
Anyone can help me?
Thanks
Hi Jose,
Try using =only(min(requesttime))
Thanks
Harshitha
Hi,
Just try Minstring() see if the field is in text format or not?
Regards,
Kaushik Solanki
Perhaps something lile
=min(Aggr(requesttime, dim1, dim2, ...))
Where dim1, dim2, ... are the other dimensions for the pivot table.
Hi,
Is in num format, because I have used min(requesttime) in a label and it works.
Hi,
But I only want the min resquesttime, I don't need the other dimensions
The dimensions in the aggr() give the context for the minimum time. The context comes from the dimensions when the min() is a chart expression, but a calculated dimension does not get that same context.
Hey you can not use the normal aggregation functions in dimension without the advanced aggregation function.
If you want to just get a minimum value then use it in expression instead of dimension.
To use in dimension you can try as below.
Aggr(Min(requesttime),Dim1)
Regards,
Kaushik Solanki
If I put this expresion "Aggr(min(requesttime),Dim1)" this will return an array, isn't it? I need only a one single value.
Is still don't working
I think, I need to find a workaround and try to do it in the script