How to implement row count without aggregating

mhouk

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.

Trending Delinquency Current Month Email.xlsx

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.