How to implement row count without aggregating
I am working on 2 different instances of data in Domo that I have pulled from our reporting software. The problem with the reports is that they natively drop property names so I only have dates and then different numbers that are stats.
I know the order that the properties are displayed but I cannot use a count of the rows exclusively since the number of days in a month changes.
Does anyone have a way to label these as their correct property?
I have included an attachment with example data the second row lists those properties by that order.
Normally I would use the Rank window but I cannot since it will asd/desc the date field and then un indexing my columns.
As a note, I'm following up with the report team to add it in but I just don't really have time to wait on them for two different reports.
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 903 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部