I need to create a new dashboard that shows customer revenue but also calculates customers gained and lost. [D66B3488-DAA3-4268-8F40-E16CF519CC09] The table would be on a running scale by month, and revenue would be totaled at the bottom for all customers. To Calculate customers won or lost I wo…

Can you please share more information regarding the data granularity of the data at the source? The approach that I would suggest you to try is : Create a calculated field to check firstValue of date for a client is equal to date field and return 1. This will give month wise number of clients add…

Thank you for your response. I think this could work maybe with some adjustments, for calculating clients added I think this approach would be pretty simple. Because we dont remove client records when they stop purchasing it would be more difficult. When a client stops being a client (i.e. they d…

Compare and Sum Columns

Q&A

Koushik_Muthanna April 15, 2024, 7:41am 4

@rsanchez.85 ,

Is this topic still open at your end and you need help (upload a sample data to Arena ? If we do not hear back in the next 7 days, we will archive the question.

Topic		Replies	Views
Flag Gained and Lost Customers by Monthly occurrence Q&A error , quick-sight , Business-Intelligence-Engineer	3	40	August 12, 2025
Detect changes between samples of the same table Q&A quick-sight , calculations	6	322	March 2, 2023
Subtract Prior Month's Running Total Exits from Current Month's Running Total Entries Q&A quick-sight , reports , dashboards , business-user	9	43	August 29, 2025
Conditional formatting comparing previous row values Q&A analysis , quick-sight , Business-Intelligence-Engineer	7	379	May 29, 2024
Percentage difference between dynamic dates Q&A quick-sight , visuals , calculations , Business-Intelligence-Engineer	3	43	February 14, 2025

Compare and Sum Columns

Related topics