Rolling of Chart by 12 months back

[dhavalvyas]

What is concept of Rolling of Bar Chart by 12 months back by selecting individual bar in chart ?

How to do this ? can anyone can explain with proper expression ?

I have data for two years from April 2015 to April 2017 ?

[neelamsaroha157]

Rolling 12 months means, looking 12 months back from the current Year-Month selection.

Ex. If you select April-2017 then rolling 12 months will be April-2017 through May-2016.

Approach you can use to accomplish this is:

Create a variable for your Max(Date).

Create another variable as AddYears(Max(Year), -1).

Add date formats as well if your original date is in different format.

Now you can use these variables in your set analysis expression.

OR you can use AsOfTables

The As-Of Table

[dhavalvyas]

This for UI

I want how to convert Date from string to Date Format then UI part.

please kindly explain

[neelamsaroha157]

Date(Date#(YourDateField, 'CurrentDateFormat'), 'OutputdateFormat')

[dhavalvyas]

what to write in current date format and output date format ??

I think so in output date format we have to write 'DD/MM/YYYY'

but what about current date format

[dhavalvyas]

can you tell quickly because I am stuck due to small mistake and I have to deploy my project with in mall period of time

[neelamsaroha157]

If your current date format is DDMMYY or any other format, you need to add that. It would be great if you can share a sample.

[dhavalvyas]

Ya i am sharing Screen Shots of my Data and Dashboard

Please reply me as soon as possible

[neelamsaroha157]

Change Date field as

Date(Date,'DD/MM/YYYY') as Date

[dhavalvyas]

Thank You So much mam. By the way where are you working ?? And Also on which tool ??