cancel
Showing results for 
Search instead for 
Did you mean: 

Running Total sum error

I'm new to Incorta and I'm trying to make insights using data I'm familiar with. The game Civilization 6 has the ability to dump json formatted files. I was able to load that into Incorta. I'm trying to make a very basic graph to show Era Score accumulated over turns:

incorta civ 6 era score.png

The problem is that when there are no events granting era score for a player on a given turn, Incorta assumes the running total is 0 as well. Am I doing something wrong or is this a bug?

4 REPLIES 4

JoeM
Community Manager
Community Manager

@phillip_benoit - I love the idea of bringing in some fun data to learn a new tool. I tried this for myself and confirm I can see the same (unless I am only plotting a single line). For that reason, I believe this isn't expected behavior and reported our PM team.

Thanks for looking in to it.

TL;DR warning for a philosophical rant about learning data science:

As far as the data goes, it's great that it's fun but it's important that it's a data set I'm familiar with. I can look at that graph and tell you that around turn 50 is when I usually get my first wonders built and turn 230 looks like when I started building spaceports to explain the changes in the rate of increase. The point of data science is to be able to make sense of what you see when you aggregate data. All due respect to the people who work on the course content but sales data is nebulous. I have no way of explaining why some products outsell others and other such questions that facilitate understanding what numbers I see and why. Only from there can I possibly hope to learn new things by looking at the data and trying to understand numbers I can't explain. If the whole data set is producing numbers I can't explain, I can't even tell when I'm doing it wrong. I'm great with computer science but data science is a skill set where I still have a lot to learn. Obscure data is a barrier to understanding that I see a lot in teaching data science. I'd be willing to bet that for people who are good at this kind of thing, any data is fine to work with. When learning how to think about data science, I find it better to look at data I know. Sociologically, I'm not sure what data would be good for teaching most people but I can tell you anything you want to know about a game of Civ6 I played.

JoeM
Community Manager
Community Manager

Adding @Prince for a sanity check here.

I went through the trouble of running the data through pyspark just to eventually find these two options:

fixed.png

 Hope this helps someone else.