Error in calculated dimension

[jmvilaplanap]

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

[Anonymous]

Hi Jose,

Try using =only(min(requesttime))

Thanks

Harshitha

[kaushiknsolanki]

Hi,

Just try Minstring() see if the field is in text format or not?

Regards,

Kaushik Solanki

[jonathandienst]

Perhaps something lile

=min(Aggr(requesttime, dim1, dim2, ...))

Where dim1, dim2, ... are the other dimensions for the pivot table.

[jmvilaplanap]

Hi,

Is in num format, because I have used min(requesttime) in a label and it works.

[jmvilaplanap]

Hi,

But I only want the min resquesttime, I don't need the other dimensions

[jonathandienst]

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.

[kaushiknsolanki]

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

[jmvilaplanap]

If I put this expresion "Aggr(min(requesttime),Dim1)" this will return an array, isn't it? I need only a one single value.

[jmvilaplanap]

Is still don't working

I think, I need to find a workaround and try to do it in the script