Select a dimension, time

[#1]

Hello,

I´m already have a few graphs created that use the dimension time like the years of the data.

This is my model:

I would like that when I select "Year" only affect the graph that i want and doesn´t alter the others. And the same for the dimension "accountYear".

Better yet, if possible, then i select the "Year" 2016 also select "accountYear" 2016, and then only affect the graph with the corresponded dimensions.

PS: some graph have the dimension "Year" and others the dimension "accountYear".

What should I do?

[vinieme12]

Apply the same set to Avg ()

[#3]

Sorry i didn´t understand...

I tried to add

RangeSum(

  Above(

    Count(

              {$<status_name = {$(vPendente)},

              account_ticket_id,

              accountYear,

              accountMonth,

              Month,

              Year,

              MonthYear = {"$(='<=' & Date(Max(MonthYear), 'MMM-YYYY'))"}>} ticket_id), 0,  RowNo())) * Avg(1)

but it is not the proper way to do it

[vinieme12]

Above(

    Count(

              {$<status_name = {$(vPendente)},

              account_ticket_id,

              accountYear,

              accountMonth,

              Month,

              Year,

              MonthYear = {"$(='<=' & Date(Max(MonthYear), 'MMM-YYYY'))"}>} ticket_id), 0,  RowNo())) * Avg({<account year, account month, account_ticket_id>}1)

[#5]

It doesn´t work. Doesn´t even appear the bar

[vinieme12]

please recheck the field names; I've not used exact field names, as I was typing on phone

Above(

    Count(

              {$<status_name = {$(vPendente)},

              account_ticket_id,

              accountYear,

              accountMonth,

              Month,

              Year,

              MonthYear = {"$(='<=' & Date(Max(MonthYear), 'MMM-YYYY'))"}>} ticket_id), 0,  RowNo()) * Avg({<account_ticket_id,              accountYear,accountMonth>}1)

[#7]

I did this: (inserted the RangeSum), double check the names but still when i select "accountYear" or "accountMonth" the graph changed...

RangeSum(

     Above(

          Count(

               {$<status_name = {$(vPendente)},

               Month,

               Year,

               account_ticket_id,

               accountYear,

               accountMonth,

               MonthYear = {"$(='<=' & Date(Max(MonthYear), 'MMM-YYYY'))"}>} ticket_id), 0,  RowNo())) * Avg({<account_ticket_id,accountYear,accountMonth>}1)