Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have below test data
Time Id
7.20.10 1
7.20.11 2
7.20.15 1
7.21.10 3
7.21.11 4
7.21.12 1
7.22.10 5
7.22.11 6
7.22.13 7
7.23.11 8
7.23.12 9
7.23.13 10
I want below expected output
Time Id
7.20 4
7.21 8
7.22 18
7.23 27
How to achieve sum of the id on aggregated time field?
I have try below expression but it not worked
sum(aggr(sum(ID),Time))
Thanks in advance.
Attaching an image and a sample
Can you provide sample data sheet so that it will be more useful. The question is not quite clear.
Hi Community,
Any idea how to write expression for above problem?
It's argent
I this time field (7.20.10)? If it is then try to create a new field in the script like this
LOAD TimeField,
Time(Floor(TimeField, 1/1440), 'h.mm') as FlooredTime,
Id
FROM ....
Now use this
Dimension
FlooredTime
Expression
Sum(Id)
Attaching an image and a sample
Hi Sunny,
Thanks for your reply.
Yes i got answer i have also done same thing.