Show data of last 10 weeks

Hi,

I have a dataset that shows data year to date. And I am using an HTML card to get a table view. Is there a filter or setting that can be set, to always show the last 10 weeks of data as time goes by? I have week column and to not overload the table, I always only want the last 10 weeks data.

Find more posts tagged with

Date

Table

HTML

Accepted answers

jaeW_at_Onyx

there's built in filtering that would allow you to filter by weeks.

alternatively you can construct a date dimension table based on TODAY() that includes a calculation for WeekNo and a WeekLag_fromToday

Capture.PNG

All comments

GrantSmith

Hi @user084060

It's indeed possible. First you'll need to sort your date in descending fashion. This will cuase the most recent records to be put first.

The next step is to then limit the number of records being displayed within the data table. In Analyzer click the Data Table to show it on the analyzer. You can then enter 10 into the text box next to Data Table atop the data table (it defaults to all rows).

Screen Shot 2020-06-23 at 1.02.24 PM.png

This will restrict your table to the first 10 rows.

user084060

@GrantSmith The challenge is that the data is on a team and consultant level, meaning that 10 rows are not equal to 10 weeks. Can you think of any other workaround?

jaeW_at_Onyx

there's built in filtering that would allow you to filter by weeks.

alternatively you can construct a date dimension table based on TODAY() that includes a calculation for WeekNo and a WeekLag_fromToday

Capture.PNG