Forum Discussion

HugoJesus's avatar
HugoJesus
Helper IV
5 years ago

Cumulative Using Summarized Data by x-axis visualizations

Hello everyone,    I've the follow table with summarized data, but it's working fine with a table, but I want to show the column Open_Tickets by Calendar in x-axis visualization, this is possible? ...
Need Help
  • HugoJesus's avatar
    HugoJesus
    Helper IV
    5 years ago

    Hi,

     

    This is a different level and my idea is to have the "Open_Tickets" in Area Chart by date.

     

    The code that I'm using is the same that you have sent before, but a little different at the end.


    Create a Measure:

     

    Total_Open_Tickets =
    var TempTable =
    SUMMARIZE
    (
    Date_Link,
    Date_Link[Calendar],
    "Created_Tickets",CALCULATE(count(Date_Link[id]),FILTER(Date_Link,Date_Link[Date_Type] = "Creation")),
    "Closed_Tickets",CALCULATE(count(Date_Link[id]),FILTER(Date_Link,Date_Link[Date_Type] = "Closure")),
    "Daily_Open_Tickets",
    CALCULATE(count(Date_Link[id]),FILTER(Date_Link,Date_Link[Date_Type] = "Creation"))
    -
    CALCULATE(count(Date_Link[id]),FILTER(Date_Link,Date_Link[Date_Type] = "Closure"))
    )
    VAR TempTable2 =
    ADDCOLUMNS (
    TempTable,
    "Open_Tickets",
    var _date = Date_Link[Calendar]
    return
    SUMX(
    FILTER(
    TempTable,
    Date_Link[Calendar]<=_date
    ),
    [Daily_Open_Tickets]
    )
    )
    return
    SUMX(TempTable2,[Open_Tickets])
     
    The result of this. .. is only showing the "Daily_Open_Tickets" instead of "Open_Tickets".
    At below, as you can see the "Open_Tickets" is the correct value and "Total_Open_Tickets" is the Measure that I've asked for help before, both are different.
    The "Total_Open_Tickets" is showing the "Daily_Open_Tickets" instead of cumulative.

    Any idea how to solve this.

     

    Regard's

    Hugo Jesus