Forum Discussion
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 ...
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.