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.

Tagged:

Best Answer

  • jaeW_at_Onyx
    jaeW_at_Onyx Budapest / Portland, OR 🟤
    Accepted Answer

    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

Answers

  • GrantSmith
    GrantSmith Indiana 🔴

    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.

  • @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?

This discussion has been closed.