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
BedrockMission!

Learn More

View all

Sign in to view all badges

How to update chart numbers to reflect most recent data

Avatar

Avatar
Boost 1
Level 1
yakhtar
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
yakhtar
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
yakhtar
Level 1

26-08-2019

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar
Validate 1
Level 2
Chris_Leyland
Level 2

Likes

3 likes

Total Posts

11 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
Chris_Leyland
Level 2

Likes

3 likes

Total Posts

11 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
Chris_Leyland
Level 2

04-09-2019

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

Avatar

Avatar
Boost 1
Level 1
yakhtar
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
yakhtar
Level 1

Like

1 like

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
yakhtar
Level 1

26-08-2019

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

Avatar
Validate 10
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Shape 1
Ignite 1
View profile

Avatar
Validate 10
Level 3
surajp86368405
Level 3

Likes

21 likes

Total Posts

77 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Shape 1
Ignite 1
View profile
surajp86368405
Level 3

26-08-2019

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