Forum Discussion
Customer Churn Report
lyasolis are you not wanting to use all the customer data at all? so you only want the users / customers who have made payments?
when you say live data, do you mean you will be pulling live data (as in live connection) or alternatively imported mode from a live database?
if its the latter, i would say merge the tables in power query and that only has a inner join kind so it will only bring back the rows that are matching and therefore filter out the unnecessary rows.
Hi vanessafvg ,
Thank you for your reply,
I want to segment users who haven't made payments, say, in April and May.
At the moment my work canvas has 2 reports:
Matrix table that gives all userID from table.Users and month by month spend per each user - so this part works fine, I can see the users who have made payments and who didn't - because there is a joint on the two tables as you suggested.
This is the issue:
Stacked Chart, that shows total revenue month by month with Currencies in Legend field (Axis: Date, UserId, Currency; Legend: Currency; Value: Amount)
So when I click on (for example) April and the USD part of the bar - the matrix report then updates and only shows me users that made payments in USD in April and so on.
But not only it doesn't explicitly show users that didn't make payments, I have no way of filtering them out anywhere as a list...
I thought since I have UserId in the Axis, it should show the ones without payments in negative on the bar chart?
Step Two - I would like those users
In regards to live data - I am new to this so correct me if I am wrong: I want the data to be updated on refresh, I will be using it for dashboard, so it's not a once off report I am looking for.
lyasolis please can you put screenshots of what you are saying /wanting/ feel free to blurr or scratch out any data that is personal if thte below doesn't help.
in your visual, under your visual level filters (right side of canvas below where you place your values, can't you filter them out there on your measure?
