Dynamic calendar view in SAC

[p2s]

Is there a way to get a dynamic view like the below

for a dynamic range too. I want the user to be able to arbitrarily select any two start and end dates from the data ideally in a calendar view.  The biggest use case is just last month, last quarter and last year but id like to have that option. Im having a hard time seeing such a functionality. Thanks!

[eeddggaarr]

Hi p2s,

as far as I know only possible with coding.
Have a look here. 
see it in action here. 
br
edgar

[p2s]

Hi @eeddggaarr , thanks for your response. I did look at that and did install the custom widget to my story. Any chance you have an example of how to connect the custom widget to the rest of the widgets on the story. I know theres a propery called onChange but i have limited experience with SAC

[eeddggaarr]

Hi p2s, linking custom widgets is explained here: https://community.sap.com/t5/technology-blogs-by-sap/how-to-use-linked-analysis-with-custom-widget/b... br edgar

[akhilgs]

Hi @p2s we have an option to create a dynamic date filter in SAC, you could try creating a story filter like below 

For current date selection either the system date can be taken or you can create an input control, in the offset specify granularity(month, year etc.) and the look back and ahead time line also you can change the date hierarchy(top right). In the above example I have created an input control for the date and set it to Sep 2023(which will act as current date), the look back time to 3 years and look ahead to 4 years, the output be like

Here the user can specify the timeline and will be able to see data  belonging to that time period.

[p2s]

Thanks @akhilgs for your response. While this solution is good for a datasource thats fixed i have a live datasource. I would have to update the value I set in the filter every time my source changes. Do you know of a more dynamic approach?

[akhilgs]

Hi @p2s the date filter is dynamic, let's assume that your live connection is bringing in data for the past 5 years as well as for the future 6 years, in that case, you would just need to change the values for look back and look ahead, this values are not fixed, the user can edit it in runtime while using the story, we are using this approach for our planning project, the same filter type, the only difference being we have an import model, where in we have 5 years of past & 5 years of present data, so when the user needs to see 10 years of data combines, they just needs to input 5 in look back & look ahead.