Count No of Records Based on unique ID
Answers
-
You can't do a count distinct inside of another count distinct. Also, unique id will always equal unique id because it evaluates by row and so you are comparing the value to itself.
Have you tried just COUNT(DISTINCT 'Records')) That actually seems to be what you are after if you have the customer id as one column and then the count of distinct records as another column.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
I think you're looking to use a Windowing function within a Beast Mode, however I do not believe that you can do a count distinct within a Windowing function ( I could be wrong on that). If it's an option you may want to consider doing it within a Magic ETL using the Rank & Window tile.
0 -
Both @MarkSnodgrass and @Giacomo are correct, you cannot nest Count Unique inside a Window Function.
... well.... you can, but the answer will be 1.
What's your use case? What question are you trying to answer?
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive