Forum Discussion

JSR's avatar
JSR
Icon for Helper II rankHelper II
6 years ago
Solved

Get data from Filtered rows

Hi, A bit lost on how best get data from specific rows so looking for any advice, thanks.   Having a table like below.   I would like to get specific filtered rows and display its info int...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi JSR ,

     

    For TITLE column, set summarisation to FIRST as highlighted below:

     

    For END DATE, set summarisation to LATEST as shiwn below:

     

    This will give you your desired result as follows:

     

    Thanks,

    Pragati

     

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

Hi JSR ,

 

You can do it easily by having a filter on CATEGORY and a Multicard to display relevant information.

  • Create a Slicer and move Category column to it.
  • Create a Muti-card and move Title, Category, End Date columns to it.

 

Now whenever you change values in the slicer, the values in the card visual gets updated:

 

Let me know if this what you are looking for.

 

Thanks,

Pragati

  • JSR's avatar
    JSR
    Icon for Helper II rankHelper II
    6 years ago

    Thanks Pragati11 for your super detailed answer.

    But I need to do the filtering automatic, and only display the latest based on Category and dates.

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

      Hi JSR ,

       

      For TITLE column, set summarisation to FIRST as highlighted below:

       

      For END DATE, set summarisation to LATEST as shiwn below:

       

      This will give you your desired result as follows:

       

      Thanks,

      Pragati