Hi All - I have tried unsuccessfully to create a view that shows the count of distinct users that have logged in the past week or month. I have tried several suggestions from multiple forum discussions, but can't quite get it to work. The closest I got was using Shawn Wallworks suggestion here. I couldn't reproduce his line chart though. See Chart 3 in the attached workbook. Everything appears to be the same as in the "5. View with flexable mark type" worksheet....but no nice graph.
I am using the Postgres workgroup database and I have the historical_events joined to the historical_event_types (only pulling "Login" event) and joining in hist_users. I'm just looking for a sum # of users that logged in (distinct).
Along with those 3 postgres tables, I was using the following:
I solved by doing the following...