Calculate the frequency of duplicates using table calculations in Looker

Lal_S
New Member

I have an explore like the following -

Timestamp Rate Count
July 1   $2.00  15
July 2   $2.00  12
July 3   $3.00  20
July 4   $3.00  25
July 5   $2.00  10

I want to get the below results -

Rate Number of days  Count
$2.00      3          37
$3.00      2          45

How can I calculate the Number of days column in the the table calculation? I don’t want the timestamp to be included in the final table.

0 0 443
0 REPLIES 0
Top Labels in this Space