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

[kaushiknsolanki]

Hi,

It will give you Min for each dimension you specify in aggregation function.

If you need overall min then use it in expression like Min({1}requesttime)

Regards,

Kaushik Solanki

[jmvilaplanap]

I need the min by each key, but this I can solve it with a TOTAL, I think. My problem now is to obtain a value in this dimension (probably will be the same value as in the previous column)

[Kushal_Chawda · Accepted solution]

your expression seems wrong

aggr(min(requesttime),Key)

[Kushal_Chawda]

or use expression

=sum({<requesttime = {"$(=timestamp(min(requesttime),'DD/MM/YYYY hh:mm:ss'))"}>} Value)

[jmvilaplanap]

Nope

[Kushal_Chawda]

In aggr expression, use Key instead key, Field name is case sensitive

[jmvilaplanap]

It works, but only for a one key (if the key is filtered)

But with this expression:

• sum({<requesttime = {"$(=min(requesttime))"}>} 1)

Now I need to modify the expression to do it for each key.

Thanks

[jmvilaplanap]

It works!

When you modify a lot of times the expression, finally you make mistakes.

Thanks!

[kaushiknsolanki]

See the attached file it works.

Regards,

Kaushik Solanki

[Kushal_Chawda]

You need to provide time format in your expression

try below

Assuming requesttime time format is DD/MM/YYYY hh:mm:ss

sum({<requesttime = {"$(=min(total <Key> requesttime),'DD/MM/YYYY hh:mm:ss'))"}>} 1)