Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to update chart numbers to reflect most recent data

yakhtar
Level 2
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.

0 Replies
surajp86368405
Level 4
Level 4

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

yakhtar
Level 2
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.

Chris_Leyland
Level 2
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