Dynamic AI Support Forum

I have a field named 'Source'. There are several text names within the Source field (SoureA, SourceB, ...). How do I add a new column (field) containing the top 10 sources?

If you want to create at top 10 list showing most used sources you can do it by grouping on 'Source', counting the transactions, sort the counting descending, and set Top=10 (please see the screenshot).

However - if you want to analyze on several different sources i the same field you need to create a view that 'explode' these values to single transactions before creating the top list.

Mikkel