I am stumped, trying to show all days in a month in a Freeform chart

[DeebyCF]

I have a simple dashboard I am trying to do where the rows are 40 different URLs with the same CID, I am trying to display Occurrences for each across each day for the previous month but Adobe is only showing me days 1-15 as columns and nothing I do can get it to show all 28-31 days. Any tips?

Thank you 

[Jennifer_Dungan]

Hi @DeebyCF,

Workspace is a great tool, but sometimes not the best for a lot of columns.

Honestly, for what you are trying to do, I would consider using Report Builder instead... The Excel interface works a lot better for 29-32 columns (if you include the URL Dimension as a column in your count), it also has side scrolling so you will actually be able to read the information easier.

If you are on a Mac, then you have to use the new Report Builder from the MS Store... if you are on Windows, you can use either the legacy or the new. The new one is easier to use, but a lot of organizations security make getting the Report Builder harder... 

Here is the MS Store version: 

https://marketplace.microsoft.com/en-us/product/office/WA200003101?tab=Overview

I did a Skill Exchange session for using Report Builder to get data into PowerPoint... you can ignore the PPT part of the presentation (or watch if you are interested), and just look at the Report Builder stuff to help get you started if you have never use Report Builder before.

https://experienceleague.adobe.com/en/docs/events/the-skill-exchange-recordings/analytics/aug2025/da... 

[DeebyCF]

Unfortunately Excel Add Ins like report builder are blocked here at work. So I will have to try to get approval for it. So in the meantime I will have to figure out a way to generate it in Workspace. I may have to break it up into multiple panels and split up the URLs as the columns and then add Days as the rows

[Jennifer_Dungan]

Yeah, it's not ideal...

Or, if you don't need metrics like Visits or Unique Visitors (something that requires de-duping), I wonder if you could use the Data Warehouse to export the data, then transpose the data in Excel (without needing to use a plugin).

[Jennifer_Dungan]

If you must have the data in Workspace, you may need to give up on the idea of have days as columns... 

OR create 31 rolling date ranges (yesterday, 2 days ago, 3 days ago, 4 days ago.... etc) and use those as columns? This is the only way I can think to ensure that the dates will properly roll... if you drag specific days in as columns, I think those days will be locked...