Creating a COUNT() Table Calculation on a dimension

Looker Q&A Looker
1

I am trying to do a very basic view. I am trying to create a calculation to show COUNT(ID) for each year.

The catch is, I do not want the ID dimension in my visual. But when I deselect it, my calculation errors out. And if I keep it, I do not get the correct output, as my Year and COUNT gets repeated for each ID.

Expected Output:
Year Count(Id)
2020 1000
2019 800
2018 1200

I know that this is possible by getting a measure created in LookML. I want to know if this is possible by just playing within Explorer and Table Calculations.

2

After some digging, it seems that this can be done via using Custom Fields(Dimensions and measures). I was not able to see it initially since the option wasn’t enabled. So had to get it activated via the admin’s help.

Hope this helps.

1 Like