2 weeks ago
Hello Community,
I am using a New Model with an Account Dimension, one Measure and one calculated Measure. In the Account Dimension, I am using two key figures, for one of them I have to use the booking date as the reference, for the other one I am using Booking date + 1 month.
It is possible to realize this with 2 converted measures, one for each key figure. But this leads to problems in the table in the story, if I want to show both key figures in one table.
I want to display it like this:
Converted Measure | |
Key figure 1 | 12 |
Key figure 2 | 10 |
But currently, it looks like this:
Converted Measure 1 | Converted Measure 2 | |
Key figure 1 | 12 | 13 |
Key figure 2 | 9 | 10 |
So my question is whether it is possible to make adjustments to a single Account Element? Or is there a different workaround?
Thanks you!
Kind regards,
Eric
Booking date can be set per converted measure and not per account so you will need 2 converted measures set with 2 booking dates. Unfortunately there is no way to provide account filters in this calculation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.