Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Need help on filter

Hi Team,

I have two table ,candidate details table and Date table,Requirment to get the details of the candidate L1 interviews status and L2 interview status based on the Reporting weeks 

This Reporting week i had created in Date table 

 

I had created an measure to get count of L1 Status Details based on the Reporting week as in the below screen shot it result like this 

 

I have a candidate table which has candidate details as shown in the below screen shot 

 

the issue is result of the L1 details is not matching with the candidate table details 

 

I need the candidate details to be as same as the L1 details table as shown in the below screen shot

 

L1 reject should be 1 and L1 Select should be 1 and No Show should be 2 as in the L1 details 

 

Could somebody help me to resolve this issue 

 

 

 

amitchandak, Greg_Deckler,

guillouzada ,

BiNavPete ,

MP-iCONN ,

mrcss23 ,

Jeanxyz ,

 v-xiaotang 

Need Help

4 Replies

  • guillouzada's avatar
    guillouzada
    Frequent Visitor
    3 years ago

    Hi Anonymous 

     

    For better understanding...

     

    Is the table below the one that you're importing to the report? 

     

    If its not could you provide a sample?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Guillouzada,

       

      Thanks for your support 

       

      yes the table I'm import from the excel data source

  • guillouzada's avatar
    guillouzada
    Frequent Visitor
    3 years ago

    So given the details table above are you expecting the result of the measure (L1 details) as follows?

     

    STATUS29-JAN-12
    L1 Reject5
    Screen Reject4
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Guillouzada,

       

      candidate table details should be matched with L1 details 

      For Example if the L1 details has L1 Reject 2 and L1 select 1

      the same count result should be shown in candidate table 

      This Candidate detail table are directly imported from the excel data source