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,
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
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)
your expression seems wrong
aggr(min(requesttime),Key)
or use expression
=sum({<requesttime = {"$(=timestamp(min(requesttime),'DD/MM/YYYY hh:mm:ss'))"}>} Value)
Nope
In aggr expression, use Key instead key, Field name is case sensitive
It works, but only for a one key (if the key is filtered)
But with this expression:
Now I need to modify the expression to do it for each key.
Thanks
It works!
When you modify a lot of times the expression, finally you make mistakes.
Thanks!
See the attached file it works.
Regards,
Kaushik Solanki
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)