Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have Table like this:
Category | READING_DATE | Value |
1711299130604 | 2019-12-03 11:05:00.000 | 4,977 |
1711299130603 | 2019-12-03 11:05:00.000 | 461 |
1711299130605 | 2019-12-03 11:05:00.000 | 65 |
1711299130602 | 2019-12-03 11:05:00.000 | 0 |
1711299130604 | 2019-12-03 09:23:00.000 | 4,964 |
1711299130603 | 2019-12-03 09:23:00.000 | 461 |
1711299130605 | 2019-12-03 09:23:00.000 | 65 |
1711299130602 | 2019-12-03 09:23:00.000 | 0 |
1711299130604 | 2019-12-03 08:44:00.000 | 4,957 |
1711299130603 | 2019-12-03 08:44:00.000 | 461 |
1711299130605 | 2019-12-03 08:44:00.000 | 65 |
1711299130602 | 2019-12-03 08:44:00.000 | 0 |
1711299130604 | 2019-12-02 20:28:00.000 | 4,883 |
1711299130603 | 2019-12-02 20:28:00.000 | 461 |
1711299130605 | 2019-12-02 20:28:00.000 | 65 |
1711299130602 | 2019-12-02 20:28:00.000 | 0 |
1711299130604 | 2019-12-02 17:40:00.000 | 4,869 |
1711299130603 | 2019-12-02 17:40:00.000 | 461 |
1711299130605 | 2019-12-02 17:40:00.000 | 65 |
1711299130602 | 2019-12-02 17:40:00.000 | 0 |
1711299130604 | 2019-12-02 16:12:00.000 | 4,860 |
1711299130603 | 2019-12-02 16:12:00.000 | 461 |
1711299130605 | 2019-12-02 16:12:00.000 | 65 |
1711299130602 | 2019-12-02 16:12:00.000 | 0 |
I need Result like this:
Result column is calculated on sum of Value with same date.
I need same like in straight Table
Category | READING_DATE | Value | Result |
1711299130604 | 2019-12-03 11:05:00.000 | 4,977 | 5502 |
1711299130603 | 2019-12-03 11:05:00.000 | 461 | 5502 |
1711299130605 | 2019-12-03 11:05:00.000 | 65 | 5502 |
1711299130602 | 2019-12-03 11:05:00.000 | 0 | 5502 |
1711299130604 | 2019-12-03 09:23:00.000 | 4,964 | 5489 |
1711299130603 | 2019-12-03 09:23:00.000 | 461 | 5489 |
1711299130605 | 2019-12-03 09:23:00.000 | 65 | 5489 |
1711299130602 | 2019-12-03 09:23:00.000 | 0 | 5489 |
1711299130604 | 2019-12-03 08:44:00.000 | 4,957 | 5482 |
1711299130603 | 2019-12-03 08:44:00.000 | 461 | 5482 |
1711299130605 | 2019-12-03 08:44:00.000 | 65 | 5482 |
1711299130602 | 2019-12-03 08:44:00.000 | 0 | 5482 |
1711299130604 | 2019-12-02 20:28:00.000 | 4,883 | 5408 |
1711299130603 | 2019-12-02 20:28:00.000 | 461 | 5408 |
1711299130605 | 2019-12-02 20:28:00.000 | 65 | 5408 |
1711299130602 | 2019-12-02 20:28:00.000 | 0 | 5408 |
1711299130604 | 2019-12-02 17:40:00.000 | 4,869 | 5394 |
1711299130603 | 2019-12-02 17:40:00.000 | 461 | 5394 |
1711299130605 | 2019-12-02 17:40:00.000 | 65 | 5394 |
1711299130602 | 2019-12-02 17:40:00.000 | 0 | 5394 |
1711299130604 | 2019-12-02 16:12:00.000 | 4,860 | 5385 |
1711299130603 | 2019-12-02 16:12:00.000 | 461 | 5385 |
1711299130605 | 2019-12-02 16:12:00.000 | 65 | 5385 |
1711299130602 | 2019-12-02 16:12:00.000 | 0 | 5385 |
Hi, you can use this expression
=Sum(TOTAL <READING_DATE> Value)
Hope this helps!
BR,
Vu Nguyen
Hi
This is working fine but I have one more question
When I use this on bar chart this does not work, its because of "Total" keyword.
How can I show this value on bar chart with drill down dimension Month and Days?
How does your expected bar chart look like (i.e which dimension and measure) ?
Measure would be same as your above expression
There will be drill down Dimension with Month and Day
First it will show by Month, when we select any month, it should drill down to Day