I have a series of observations for 4 catagories taken at random times over a 2 year period that I want to display in Insights. On occasion observations are captured once a week, sometimes once a month for all 4 catagories. The issue I have is that Insights automatically chooses the time periods along the x axis and aggregates the observations during this period into a total for that period Insights selects. I don't want to know the total aggregated during the period I want to maintain the actual count. The graphs below demonstrate this. They look completely different due to the automatic aggregation. Does anyone know how I can overcome this problem?
Solved! Go to Solution.
Does your Y-axis have two measures? It looks like it's doing sum and average.
Yes sum of frequency and average of Time Series. I want just sum of frequencies.
average of Time Series Cluster.
Would it be possible to send a copy of the data?
I was finally able to get this to work. Changing my cluster id field from number to string was the solution.