Question

Calculate the frequency of duplicates using table calculations in Looker

  • 28 September 2020
  • 0 replies
  • 131 views

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 replies

Be the first to reply!

Reply