Forum Discussion
Create variable to user in Metrics/Reports data
Thank you. I am able to create a new parameter. But how do I use it in the filter.
e.g I want to put Project Date < Parameter Value. When I put this filter, basically my revenue should show only until the cut off date of Parameter value.
And I want to apply it to all the reports and metrics. Sometimes to a specific metric in the report but not at report level.
Meaning, I can have a metric to show the data untill the Parameter Value and another metric independant of Parameter value.
Regards,
Akash
akj2784,
After you set a date value for the parameter, go to Date fields of your tables, then filter the Date fields to be "is before or equal to" parameter, there is an example for your reference.
Regards,
Lydia
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.
To give you a context. I am using W_DAY_D joined to Revenue Fact and Forecast Fact.
Revenue is always untill the parameter date. However Forecast is always for future date. So if I restrict it to parameter value at W_DAY_D table level, I may not be able to see forecast data.
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,
LydiaLet 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.