cumulative sum line chart with calculated dimension, problem with series
Hi, I have a problem with cumulative sum line chart, the problem is I think I need to aggr by dimension, but im usin calculated one, and puting it in the formula gives rubbish chart result. So I'm playin with covid19 data. Columns of interest: date, cases, deaths, country. Ive calculated on visualisation purposes dimension like: day_0: =Aggr(nodistinct min({<cases=-{'0'}>}date),countriesAndTerritories)
I want to show it as a line chart, with day_count and country as dimensions. When i filter one country its, ok, problem is when i want to show more countries as a series. Then instead of something like that (example from power bi):