The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
I am trying ot use bupaR for some process mining, but after I generate the eventlog with bupaR, the visuals created with the other libraries (e.g. diagrammeR) only show maximum 16 cases out of 120k.
I've read in documentation that powerBI supports up to 150k cases in R visuals.
Could someone please point to me what I am doing wrong?
my dataset contains the following columns:
ContractId | Status | LastUpdate | Project | Contract Type | Index |
the R script I am using is the following:
# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:
# dataset <- data.frame(CONTRACTID)
# dataset <- unique(dataset)
# Paste or type your script code here:
library(bupaR)
library(DiagrammeR)
Query1 <- dataset
Query1$LASTUPDATE <- as.POSIXct(Query1$LASTUPDATE, tz="GMT", format = c("%Y-%m-$d %H:%M:%S"))
x <- Query1 %>%
eventlog(
activity_id="STATUS",
case_id="CONTRACTID",
resource_id="PROJECT",
activity_instance_id="INDEX",
lifecycle_id="CONTRACTTYPE",
timestamp="LASTUPDATE"
) %>% filter_endpoints(start_activities= "Draft", end_activities= "Expired")
y <- process_map(x, render=FALSE)
export_graph(y, "result.png", file_type = "png")
This is the visual being generated:
Thank you in advance for the help.