Best way to show data after some event takes place

[stribor45]

I was hoping to have some advice on what is best way to show following data.

• I have users who may have one parking ticket or more. Each user have unique ID and each ticket has unique ID
• All of these tickets are currently not paid
• I am going to send each of them an email

I want to show list of users who paid the ticket after the email is sent. My goal is to analyze and see if sending email enticed users to pay or not.

Thanks

[Anonymous]

Hi @stribor45 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[DataNinja777 · Accepted solution]

Hi @stribor45 ,

To effectively analyze whether sending emails influenced users to pay their out

standing parking tickets, you can structure your dataset to track payments before and after the email was sent. A comparison table that shows each user's payment status change over time is the best way to present this.

Here's a sample table structure to visualize the data:

User ID	Ticket ID	Email Sent Date	Payment Date	Paid After Email?
101	T001	1/1/2025	1/3/2025	Yes
102	T002	1/1/2025	-	No
103	T003	1/1/2025	1/5/2025	Yes
104	T004	1/1/2025	12/29/2024	No (Paid Before)

Key Insights are as follows:

1. "Paid After Email?" is a calculated field that shows whether a payment occurred after the email date. You can flag users who paid post-email to assess the effectiveness.
2. Use a DAX measure in Power BI to count the percentage of users who paid after receiving the email, enabling you to track trends and measure impact.

For example:

Paid After Email % = 
DIVIDE(
    COUNTROWS(FILTER(Payments, Payments[Paid After Email?] = "Yes")),
    COUNTROWS(Payments),
    0
)

This table makes it easy to see which users responded to the email and provides a clear, actionable metric for assessing your communication strategy's success.

Best regards,

[stribor45]

Thank you. I will try this and let you know.

[danextian]

Hi @stribor45 

When it comes to things like this when I am unsure how data are to be visualized, I ask AI for guides.

Here's what I got form ChatGPT https://chatgpt.com/share/677a0546-ddb0-8000-b15f-84512099e282

[Ashish_Mathur]

Hi,

Share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.