Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

Create variable to user in Metrics/Reports data

Hi Team,   I have a requirement to use a variable to filter the metrics data, or sometimes put filter at the report level too. e.g If I have a revenue metric, I want to see the revenue untill the ...
Need Help
akj2784's avatar
akj2784
Post Partisan
8 years ago

If I do that at table level, it will always restrict the data untill the parameter value which I don't want. At some place I don't want this filter to be applicable. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

akj2784,

In the following screenshot, you can choose different filters(equal to, is before or equal to) for different tables.


If you still have questions, please share sample data of your tables and post expected result. 


Regards,
Lydia

  • akj2784's avatar
    akj2784
    Post Partisan
    8 years ago

    Let me try to explain again.

    W_DAY_D is a common day dimension which is joined to Revenue and forecast Fact on some FKs.

    Revenue and Forecast fact will not have the date column. 

    I want to apply this parameter filter only to Revenue Fact joined to w_day_d and NOT to Forecast joined with w_day_d.

     

    With your method, I can apply the parameter filter at table level which may not help in my case.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      akj2784,

      In your scenario, the parameter method may not be suitable for your scenario, you may need to create different measures to return the expected result.

      If you have any questions about creating measures, please share sample data of your tables and post desired output so that we can provide you appropriate suggestions.

      Regards,
      Lydia