Forum Discussion

MichaelJackpbi's avatar
MichaelJackpbi
Icon for Helper I rankHelper I
9 years ago
Solved

Get data for 1 week before depend on TODAY()

Hi friends, I would to load data for 1 week only depend on current date!. I.e. Today is 12/14/2014 then my dataset will get data from 12/7/2016 to 12/14/2016 AND tomorrow, my dataset will load data ...
Need Help
  • tringuyenminh92's avatar
    tringuyenminh92
    9 years ago

     

    Hi MichaelJackpbi,

     

    In Query Editor, Choose your date column -> click filter icon in top right of header of column -> choose Date Filters -> Custom Filter -> Fill in This quarter and Last quarter with OR operator as below pictures:

    (Every actions have been done by UI - love it )

     

     

    Back to your speed question, depends on your query(or amount of data) the loading time will be fast or slow. That means it will take more time when loading data for quarter than week. And i hope you have good index stategy in your sources. it's one important factor.

    • Import mode: loading all data of your query - one time when refreshing - good for UX
    • Direct Query: loading data based on user's interaction (user could choose an option in slicer -> system generates the query corresponding and just loads the data of that query) - user has to wait when loading huge data of that action or long distance of data center to user's location

     

     

     

     

MichaelJackpbi's avatar
MichaelJackpbi
Icon for Helper I rankHelper I
9 years ago

Hi tringuyenminh92  It souunds great ! But i still confuse about the data loading speed, may the edit effect to the speed? in case i would keep the rows for 2 Quarters - current Quater & Last Quater, how to do that?

Thanks,

J.

tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
9 years ago

 

Hi MichaelJackpbi,

 

In Query Editor, Choose your date column -> click filter icon in top right of header of column -> choose Date Filters -> Custom Filter -> Fill in This quarter and Last quarter with OR operator as below pictures:

(Every actions have been done by UI - love it )

 

 

Back to your speed question, depends on your query(or amount of data) the loading time will be fast or slow. That means it will take more time when loading data for quarter than week. And i hope you have good index stategy in your sources. it's one important factor.

  • Import mode: loading all data of your query - one time when refreshing - good for UX
  • Direct Query: loading data based on user's interaction (user could choose an option in slicer -> system generates the query corresponding and just loads the data of that query) - user has to wait when loading huge data of that action or long distance of data center to user's location