SAS Visual Analytics

Dashboards, reports, BI and analytics - all from a single interface.
BookmarkSubscribeRSS Feed
barada1
Calcite | Level 5

Hi Folks,

 

How to Calculated YTD & MTD as Categorical Variable?

 

 we wanted to use YTD & MTD as category rather than Aggregated measures so that we can control the Premium & policies through the control panel with respect to YTD & MTD. Though it can be achieved through Cumulative & Parallel Period ,it can be only used as Aggregated measures not Category.

 

Can you suggest any solution for this particular problem ?

 

Regards,

Prasanna

1 REPLY 1
alineagostini
Obsidian | Level 7

Hi,

 

This article may not be specific to your case but it can give some insights on how YTD and MTD variables could be created as categories and then applied as filters / parameters. In this case, the data prep is the key. Maybe you could use part of it to solve your problem.

 

https://communities.sas.com/t5/SAS-Communities-Library/Making-VA-reports-more-dynamic-category-measu...

 

Hope it helps.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1468 views
  • 0 likes
  • 2 in conversation