Hello,
I have below problem statement.
I have created a table as follows which filters data to be from the last 7 days (Important as date window shifts +1 date every day)
TABLE 1
Name | Date | Value
A | 2021-05-26 20:39:15.3366667 | 2
B | 2021-05-26 17:32:15.3366667 | 1
C | 2021-05-26 21:37:15.3366667 | 4
D | 2021-05-26 15:38:11.3366667 | 10
A | 2021-05-26 20:29:15.3366667 | 12
B | 2021-05-26 17:35:15.3366667 | 22
C | 2021-05-26 21:17:15.3366667 | 12
D | 2021-05-26 15:31:11.3366667 | 19
A | 2021-05-25 20:36:15.3366667 | 4
B | 2021-05-25 16:34:15.3366667 | 6
C | 2021-05-25 23:32:15.3366667 | 5
D | 2021-05-25 22:59:15.3366667 | 11
.
and so on.
I am able to pivot this table using the visualization to be:
Table 2
Name | 2021-05-26 | 2021-05-25 | 2021-05-24 | 2021-05-23 | 2021-05-22 | .....
A | 14 | 4 | ....
B | 23 | 6 | ....
C | 16 | 5 | ....
D | 29 | 11 | ....
I can add TABLE 2 to my dashboard and it looks great. But when using the subscription feature to email the results out daily to a client, the table is no longer pivoted and just shows up as the original unpivoted table (TABLE 1). Note: client does not have a metabase account so we can only email them the results
What is the simpliest way I can manually create TABLE 2, keeping in mind that 7 day window shifts every day?
on the first post