Filter line/bar chart with current year data but showing totals

Looker Q&A Looker
1

Basically what the titles says.

I have a graph (works on line, bar chart or time series) that shows the evolution of total registrations to our program. I already have another slide with the whole totals from the beginning of the program (historic, so to speak), but I want another slide similar to that that shows only this current year.

The problem is that when I choose to filter for only year to date, it doesn’t show the totals, it starts in January with only the new users from January. I’d like it to show the total from January and the evolution for the following months

Example: right now it shows that we got 200 new users in January, good, but we started with a total of 12300 users, so in January I’d want to see 12500, which is the total users we had at that moment.

I searched many different other forum entries and such, and tried different solutions (like adding certain filters and stuff) but none have helped. They either scramble the data, show only the current year totals without taking into account previous totals, or does nothing. I’m running out of ideas.

Any solutions? Or anyone to point me in the right direction if there’s an article/video somewhere I missed?

Thanks!

2

would it solve the problem, when you use a calculated field that simply adds 12300 to your metric instead of the original metric?

3

One option would be to add a table calculation that determines which rows (months) you want to display in your chart rather than filtering the full dataset.

So your rows would be cumulative users by month from the beginning of the program.
Then you’d have a table calc column that calculates “current year” as “yes” and you’d use the built in hide no’s from viz feature. Then only the current year rows would show

image
image189×239 12.8 KB