Option to select daily granularity #71

mattiasback · 2022-02-21T12:49:58Z

mattiasback
Feb 21, 2022

I would like the option to sum the rewards by daily granularity in order to reduce numbers of entries from 1000's to 365.

Thanks for a great tool.

Answered by davetapley

You can actually do this all in Google Sheets using a pivot table!

Import .csv
Add new column to right of column A
In blank cell B2 enter formula =DATEVALUE(MID(A2,1,10) and accept autofill
Select 'Insert' then 'Pivot Table'
On new pivot table:
a. Under 'Rows' select 'Column B'
b. Under 'Values' select 'USD'

It should look like this:

davetapley · 2022-02-21T17:34:06Z

You can actually do this all in Google Sheets using a pivot table!

Import .csv
Add new column to right of column A
In blank cell B2 enter formula =DATEVALUE(MID(A2,1,10) and accept autofill
Select 'Insert' then 'Pivot Table'
On new pivot table:
a. Under 'Rows' select 'Column B'
b. Under 'Values' select 'USD'

It should look like this:

0 replies