can a custom report be made to have a column per d...
# generalc
Castor
03/19/2025, 6:27 PMcan a custom report be made to have a column per day?
j
James Morris
03/19/2025, 6:59 PMYeah, you can do that using the Alternative Date Range, but you might have to change your report by period settings (Home > Set Preferences > Report by Period) and doing this could mess up other reports if you need them by period versus date.
c
Castor
03/19/2025, 7:18 PMI don't think that allows for us to do the day by day scenario.
i.e I'd want 28 columns for a february report
31 in march...
j
James Morris
03/19/2025, 7:22 PMYeah, it's definitely not going to dynamically change the number of columns if that's what you're wanting. There are a few dynamic selectors, but they are limited (i.e. you couldn't get a full month of columns), and even then it wouldn't change the number of columns.
James Morris
03/19/2025, 7:24 PMBest you could do for reports is setup those columns manually to in theory get the output you're looking for, it's just not going to dynamically update itself.
James Morris
03/19/2025, 7:27 PMIf you're married to reports, I think you're stuck. This is doable in saved searches using formulas (but would be fairly cumbersome/time-taking). Also maybe possibly in analytics workbooks, but not sure I've played around with this enough to opine with authority.
c
Castor
03/19/2025, 7:34 PMI chose to do a workbook
Castor
03/19/2025, 7:35 PMYou can't get more than 'five days ago' in report relatives.
2 Views