topic Re: Gain/loss for a subscription in App Development

Gain/loss for a subscription

JeroenHoltrop — Thu, 09 Apr 2020 06:40:50 GMT

Hi,

I want to create an overview of all gains/losses over a selected period for a product which has a start and enddate. So we sell subscription-like products, where a gain is when the start date is in the selected period and a loss is where the end date is in the same selected period.

Since the date selection is only able to be connected to either the start or end-date dimension, I have tried other things, which weren't successfull:

1. Added a new date dimension which is apart from my data model to be able to select the date range and then make a selection on field level in the table. This doesn't work, because the report tells me that this is an invalid dimension. When pushing these values into variables, it does work once, but it doesn't refresh my data after date changes.

2. 2 date selectors and a switch whether the user wants to see the gains or losses. This is far from a neat user experience, and also doesn't work, because the 2 selectors cannot have the same dates.

The only option I see now, is to completely divide the 2, but then I lose a lot of insights which I can provide if I could combine the 2 obviously.

Any help would be very much appreciated

Re: Gain/loss for a subscription

usamabinsadiq — Thu, 09 Apr 2020 08:32:01 GMT

please provide example data to work with,

thanks

Re: Gain/loss for a subscription

JeroenHoltrop — Thu, 09 Apr 2020 08:41:55 GMT

Hi,

So here is an example of the data (dates are dd-mm-yyyy)

#	start date	end date
1	01-03-2019	01-03-2020
2	01-05-2019	01-05-2022
3	01-03-2020	01-03-2022
4	01-02-2020	12-03-2020

So, I want to create my gain/loss report based on the period March 2020, where I see that I have a loss in contract 1 and 4 and a gain in contract 3. Contract 2 is active, and will therefore be ignored in this period for this report.

Does this makes sense?