Showing rows only with multiple events

[farheenayesha]

Hi,

In a pivot able, i want to show event dates which has multiple events as below. In the below image, event date 01/03/2016,01/04/2016 and 01/05/2017 has multiple curriculum names and speaker names, hence i want to display only these dates.

     Dates like 01/02/2016 and 01/06/2017 are having single curriculum name and speaker name, hence i want to eliminate these rows.

Kindly help.

In the below image, i want only rows highlighted in green color and remove which are highlighted in red. Please find the excel and QVW attached.

[farheenayesha]

Thanks Sunny.

However I didn't get the solution yet. I am attaching new Mockup data and Sample file. Please help me to achieve it. I want only records which has multiple event start date where 'date trained' is null.

in the below snapshot I have only one record with date trained is null and I want to remove this record from the table.

I have to achieve this in front end level.

Please let me know if you want more clarification.

afd‌

[sunny_talwar]

Which table are you looking to remove it from? Speakers Pending Training table?

[farheenayesha]

Yes Sunny. I am trying to remove all the single records where date trained is null.

[sunny_talwar]

Is this based on Event Start Date? What will you want to see when 1/6/2016 is selected?

Both the rows because 1/6/2016 have more then one Event ID?

[farheenayesha]

yes.

Logic : I want to display records which has multiple curriculum id's for one Event start date and also date trained should be null.

When I select 1/6/2016, I should get only two records where date trained is null, as same as your snapshot. However for the date 1/4/2016 , I want to remove the record which is appearing in the Speaker Pending Training Table. Because it has only one record with date trained as null.

[sunny_talwar · Accepted solution]

Try this as a calculated dimension

=Aggr(If(Count(TOTAL <[Event Start Date]> DISTINCT {<[Event Status]-={'DROPPED','HOLD','CANCEL'},[Event Type]={'SPKRPGM'},[Site Participant Attendance Status]={'ACCEPTED','ATTENDED'}>}If(Len(Trim([Date Trained])) = 0, [Vendor Event ID])) > 1, [Vendor Event ID]), [Event Start Date], [Vendor Event ID])

[farheenayesha]

You are Genius Thank you so much. I am very grateful to you!!

[farheenayesha]

Hi Sunny,

Just wanted one more scenario. As I had mentioned that I want to show Event start date with Multiple Curriculum ID's and date trained is null. I want more condition to be added. Along with multiple curriculum id's I want to show event start date with multiple site participant SFDC ID as well. In the below image, event dates with multiple site participant SFDC ID is not showing up in the actual table(Second Image).

There is one issue in the solution what you have shared with me. As I want Site Participant SFDC ID as only Attended accepted, However in the current solution, I am seeing the records with Declined and Do Not Show as well. It would be great if you could help me to resolve these two issues.

[farheenayesha]

Thank you so much for your response

[sunny_talwar]

I did not see any reference of SFDC ID... what exactly is SFDC ID? And just to be clear, you have two issues above....1) The previous expression isn't working exactly how you would wish, 2) You want to add another condition, correct?