Showing Data: Table (1 month) & Chart (13 month)

[nwilliams]

Hi,

I have a data set of 15 months worth of HR data.  I have a list box with the "MonthName" in it.  What I am trying to achieve is:

When you select a "MonthName" the table will show details relating to that month, and the chart will show data for that month, plus the last 12 months, split out using "MonthName" as a dimension.

Any ideas?

[sushil353 · Accepted solution]

Hi,

In the chart you can write your expression as Sum({<MonthYear = {">=$(=Addmonths(Max(MonthYear),-12)) <=$(=Max(MonthYear))"}>}Sales)

HTH

Sushil

[nwilliams]

Great!!! Thanks!!!

[prashantbaste]

Please find attached QVW & let me know if it resolves your query.

--

Regards,

Prashant P Baste

[nwilliams]

Hi,

The above has been working great until now.  When I try and put the above in the below formula, it doesn't work

=(
Sum(Aggr(Sum(DISTINCT
{<[QueueInteractionsView.c_QueueGroup]={'Service Desk'}>}
InteractionsView.TotalQueueTime), lnk_InteractionId))
/
Count (DISTINCT
{<
[QueueInteractionsView.c_QueueGroup]={'Service Desk'}>}
QueueInteractionsView.IID))

The above formula gives me an ava wait time.  what I want to do is chart this over 12 months, but have the current month selected in the calendar.  Any thoughts?