Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

How to update chart numbers to reflect most recent data

Avatar

Level 2

I have a workspace which captures week over week and month over month numbers. How do I make sure that each week my most recent numbers are captured. Right now each week I have to go and change the selected position.

Thanks in advance.

1 Accepted Solution

Avatar

Correct answer by
Level 5

you can always build custom time dimensions. click on the plus besides time in analysis workspace.

1821748_pastedImage_1.png

use the rolling dates option to create the filter according to your requirements.

1821747_pastedImage_0.png

View solution in original post

3 Replies

Avatar

Correct answer by
Level 5

you can always build custom time dimensions. click on the plus besides time in analysis workspace.

1821748_pastedImage_1.png

use the rolling dates option to create the filter according to your requirements.

1821747_pastedImage_0.png

Avatar

Level 2

Thanks for taking the time out to reply Surajp86368405 . I do have a custom time period that does exactly what you are suggesting.

The issue I am having is that when a new week starts my summary number which I am visualizing does not update to the new week's number and stays on last week's number.

Avatar

Level 2

Hi Yakhtar,

So using your calculated time periods, you could generate a table that looks like the below;

1827141_pastedImage_0.png

So rather than the week breakdown in your table, meaning that you need to go update the cell your summary visualisation is pointing at, you can just point your summary number vis at the visits from "this week" (calculated date period to show the last 7 days, rolling), then do your summary comparison vis showing the difference between "last week" (calculated date period to show the last 15 days to 8 days ago, rolling).

This means that each time you open this dashboard, this will update to give you the present week's data in the summary number & summary change visualisations without having to change which cell your visualisation is looking at.

Thanks,

Chris