Forum Discussion
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? ...
HugoJesus , Your table structure is not clear.
I have a blog on a similar topic : https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
And cumulative of open(current employee added to file attached after signature .
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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.
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