personeelData %>%
filter(!is.na(aanpakkosten)) %>%
group_by(aanpakno, stardatum, gemeentenaam, aanpakomschrijving, aanpakkosten) %>%
summarise(sumPers = sum(personeelskosten)) %>%
group_by(aanpakno, gemeentenaam, aanpakomschrijving) %>%
summarise(totPersK = sum(sumPers), totAanK = sum(aanpakkosten), totKost = sum(totAanK+totPersK)) %>%
arrange(desc(totKost))
This is the code i have used to tidy my data. Now i want to plot it using a geom_col() for every cost type. which are totPersK, totAanK and totKost. I just want them to be stacked upon each other. I can't seem to figure this one out. Maybe someone can help me? I am still learning.
Thanks in advance,
Kevin