Forum Discussion
HugoJesus
Helper IV
Helper IVCumulative 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? ...
Fowmy
Super User
Super UserHugoJesus
Try this code please:
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 LastDay =
MAX ( Date_Link[Calendar] )
VAR TempTable2 =
ADDCOLUMNS (
TempTable,
"Open_Tickets",
VAR _date = [Calendar]
RETURN
SUMX ( FILTER ( TempTable, [Calendar] <= _date ), [Daily_Open_Tickets] )
)
RETURN
ADDCOLUMNS(
TempTable2,
"Cummulative",
SUMX( FILTER(TempTable2, Date_Link[Calendar] <= EARLIER(Date_Link[Calendar])), [Daily_Open_Tickets])
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
FowmySuper User
Super UserHugoJesus
Do you still need the OPEN_TICKETS column? If not, change the code after the RETURN as below and try.
ADDCOLUMNS(
TempTable,
"Cummulative",
SUMX( FILTER(TempTable, Date_Link[Calendar] <= EARLIER(Date_Link[Calendar])), [Daily_Open_Tickets])
)
You may share a PBIX file with sample data or an excel sample file to test the same.
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
-------------------------------------------------
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂