emergency :) filter

YannRC — Thu, 10 Oct 2024 21:16:54 GMT

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?

Re: emergency :) filter

Sam_SAS — Thu, 10 Oct 2024 21:37:46 GMT

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

topic Re: emergency :) filter in SAS Visual Analytics

emergency :) filter

Re: emergency :) filter