Forum Discussion

frankhofmans's avatar
frankhofmans
Icon for Helper IV rankHelper IV
6 years ago

Link matrix or table to date slicer

hi all,

 

i have the following table or matrix i want to present:

 

Case IDStart DateEnd dateName
00101-01-202010-02-2020

Mike

00210-01-202013-02-2020Lisa
00315-01-202015-02-2020John
00416-01-202016-02-2020Frank
00520-01-202020-02-2020Sarah
00630-01-202001-03-2020George

 

I have added a indirect relation between start-date and my date table. When i want to add a date slicer (for example week number) the matrix or table doesn't change when i select fe only week 1 and 2 (case id 004, 005, 006 are still in the matrix). Any ideas how to link this kind of table or matrix with a date slicer?

 

thanks in advance!

 

Regards,

 

Frank

Need Help

2 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    Hi frankhofmans ,

     

    Can you please share screesnhot of your data model here with relationships that you have created?

     

    Thanks,

    Pragati

     

    • frankhofmans's avatar
      frankhofmans
      Icon for Helper IV rankHelper IV
      6 years ago

      hi Pragati,

       

      i think i solved it. i used the following measure: Is in range = VAR r = CALCULATE( COUNTROWS(Data), USERELATIONSHIP( Date,start_date ) ) RETURN IF(ISBLANK(r), 0, r)

       

      thanks for the quick response,

       

      Regards,

      Frank