Hi all,
I have a BAQ i created and its showing me what i want i now want to filter it down a bit more.
I’m look for all parts that have 2 or more entries like the one below, am i able to only show these entries?(It’s just grouped on part atm)
You can count them with a windowing function in a calculated field.
count(1) over (partition by Table.field1, table.field2, tables.field1 etc)
Your partitions (the Table.field1) would be the same as what you are grouping by in your screen. This will give you a column with the counts in it. You can then either filter in the dashboard, or in your BAQ drop the top level to a subquery, and bring it into a new top level and do a table filter there.
2 Likes
Check out this video, it will show you how to do a bunch of different calculated fields like I just showed you there.
1 Like
Thank You, go it working and i’ll check out the video aswell