Forum Discussion

JSR's avatar
JSR
Helper II
5 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
    5 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
Super User
5 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
Helper II
5 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
    Super User
    5 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