Timeframe and stock measure

SiMor — Tue, 10 Sep 2019 08:27:22 GMT

Hi,

i need some help with the measure of stock.

For each timeframe, month, quarter and year i need to sum just the value of the last month in the timeframe so that the value of march 2019 is the same of the first quarter of 2019.

Could someone help me?

Thank you

Re: Timeframe and stock measure

FredrikE — Tue, 10 Sep 2019 09:02:06 GMT

I have solved it by using a calculated dimension for time. I have a button bar with the different possible time dimensions (day, month, quarter and year) I have assigned a parameter to the button bar.

In my graph objects i use this calculated dimension as category.

On the objects I have created a dynamic filter that uses the parameter to decide which time period to show.

In my data i have a flag for last day of month, last day of quarter and last day of year. I use these in the dynamic filter

//Fredrik

topic Timeframe and stock measure in SAS Visual Analytics

Timeframe and stock measure

Re: Timeframe and stock measure