Forum Discussion

Manjula's avatar
Manjula
Helper I
3 years ago

undefined

Hi All,

I have two fact tables SSLA and TLA, i need to add a field in card visual in the report which is from TLA table 
I have already created a report from SSLA table , but new requirement is to add the one more field in card visual from TLA table.
so i have appended the two tables and when i filter on date(from SSLA table) the card value is not filtering correct value,  when i take date field from append table the card value is showing correct but the previous report need to filtered on Date filter from SSLA table

Suggest me pls

Need Help

1 Reply

  • Gowtham_Selvam's avatar
    Gowtham_Selvam
    Resolver I
    3 years ago

    You need to have a date dimension table while filtering the data based on date.

     

    If I answered your question,kindly mark it as solution.

     

    Thanks,

    GS