I would like to filter my data in the load script or using set expression . I do not want to use a filter chart. I have a dimension [Customer Satisfaction Rating Date]. I need to load only yesterday's rating using set expression or in the load script . Thanks for your suggestions.
Then use a set expression like this. Assuming you are using avg([Customer Satisfaction Rating]) as core calculation. Also assuming that your [Customer Satisfaction Rating Date] is formated as your default date format.
Thanks Vegar but this is a straight table. I do not wish to use aggregation. I just need the table to show only previous days ratings and Monday's rating should show Friday's rating as previous day. Below is how my table looks like. Thanks