Show all even when date is selected

[bobbydave]

This is a strange question ... I know before I even start but ....

I have a page with calendar  that shows the relevant data assigned to Year and Month.

However on this page, I need a chart to show the full year so far (and as the months of this year continue, the chart expands with the year and month also. But if the Year selected is 2016 and the Month is May, I don't want this chart to show only 2016 and May, it should show the full year so far while the other data on the page does show 2016 and May.

I only want this one chart to show the full years data.

Any ideas?

[sunny_talwar]

Can you check the attached

[bobbydave]

Hi Sunny,

I am definitely not explaining myself correctly.

I've removed the other tables and left the only table I need.

So right now I have selected 2016 March in the application.

In the Average Speed table, I want ALL of the Average Speed for 2016 to appear even though I have selected the dates  2016 March in the calendar.

The Average Speed should have the current years data appearing from Jan to today.

[sunny_talwar · Accepted solution]

Try now and see if this is what you want. I have created two tables, Average Speed 1 is always going to show current year's average speed no matter what year you select in your application. Average Speed 2 will change based on your selection in Year field (but will still show the complete year

Average Speed 1 Expression:

Num((Count({<group= {'AXA_LPI:Service_Desk',

  'AXA_LPI:New_User_Setup',

  'AXA_LPI:New_TIA_User_Setup',

  'AXA_LPI:VTC_Requests',

  'AXA_LPI:TIA_ROFC'}, Year = {$(=Year(Today()))}, Month, Date>} TV_Number)

)/(Num(Sum({<group= {'AXA_LPI:Service_Desk',

  'AXA_LPI:New_User_Setup',

  'AXA_LPI:New_TIA_User_Setup',

  'AXA_LPI:VTC_Requests',

  'AXA_LPI:TIA_ROFC'}, Year = {$(=Year(Today()))}, Month, Date>} TV_Open_Days), '#.##')

), '#.##')

Average Speed 2 Expression:

Num((Count({<group= {'AXA_LPI:Service_Desk',

  'AXA_LPI:New_User_Setup',

  'AXA_LPI:New_TIA_User_Setup',

  'AXA_LPI:VTC_Requests',

  'AXA_LPI:TIA_ROFC'}, Year = {$(=Max(Year))}, Month>} TV_Number)

)/(Num(Sum({<group= {'AXA_LPI:Service_Desk',

  'AXA_LPI:New_User_Setup',

  'AXA_LPI:New_TIA_User_Setup',

  'AXA_LPI:VTC_Requests',

  'AXA_LPI:TIA_ROFC'}, Year = {$(=Max(Year))}, Month>} TV_Open_Days), '#.##')

), '#.##')

[bobbydave]

Hi Sunny,

Thanks so much.

Average Speed Two works perfect now once I add YearMonth in as a dimension.

This is what I was trying to do.

Thanks so much

[sunny_talwar]

So is everything working now? If it is, I would request you to close this thread by marking correct and helpful responses.

Best,

Sunny