emergency :) filter

[YannRC]

Hi everyone,

I have an emergency because i have to solve something Quickly.

I have a database with several update in the same day. I would like to measure only with the mast update.

But it's impossible to filter with something like that. dateofupdate = max(forall, Dateofupdate) because an aggregate data is not allowed on a filter.

Do you have a solution please?

[Sam_SAS · Accepted solution]

Hello,

I'm not sure of the structure of your underlying data. Are you showing the detail data, or is it aggregated? And, is your Frequence a real measure column or is it the generated Frequency that is derived automatically?

If your data is actually that simple, you could try just changing the date column to a format that doesn't have a time component. Then all of the rows for each date could be aggregated by Max.

Otherwise you could try creating an aggregated data source. https://documentation.sas.com/doc/en/vacdc/v_027/vareportdata/n1o2pvak2xw7jln13a2mxkytdmm4.htm

Let us know if that helps,

Sam