Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Apply the same set to Avg ()
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
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)
It doesn´t work. Doesn´t even appear the bar
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)
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)