How to list the most used values?

Say in note A I have

key:: [[value1]]
key:: [[value2]]

and in note B I have:

key:: [[value1]]

I want to have a list that say

- value1: 2
- value2: 1

Is that possible?

Hi :slight_smile:
An example for key21:

  1. retaining value as a link
LIST WITHOUT ID K + ": " + length(rows)
WHERE key21
FLATTEN key21
GROUP BY key21 AS K
SORT length(rows) DESC
  1. value as a string
LIST WITHOUT ID meta(K).path + ": " + length(rows)
WHERE key21
FLATTEN key21
GROUP BY key21 AS K
SORT length(rows) DESC

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.