Hello, You could achieve your desired output alternatively by distinct Count on tableName. I am attaching the screenshot for you to try this approach. Please let me know if this helped you solve the problem.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Comparing multiple dimensions with same outcome | 6 | 93 | June 21, 2024 | |
| distinctCountOver if condition | 2 | 2453 | March 31, 2023 | |
| Distinct count with conditional function | 5 | 195 | March 7, 2024 | |
| distinctCountOver() throwing SQL exceptions with any ifelse() in First Argument | 7 | 98 | September 10, 2025 | |
| Calculated field count groupby based on attribute values | 2 | 1298 | October 12, 2022 |