on 05-08-2018 9:11 AM
In Data view I have a large number of dimensions and want to reduce the number temporarily so I can compare three Dimensions that are not close to one another. in Lumria 1 there was a feature to hide dimensions in the data view. Has this been feature been removed?
I found a work around
1st you need to know if today's date is part of a complete month so create a new dimension (A) and custom calculation =LastDayOfMonth({Date you want to interrogate}) - CurrentDate()
next you want to limit your date period to the last 12 months so create a new dimension so create a new dimension (B) and custom calculation if Year(CurrentDate()) - Year(Date you want to interrogate) <= 1 and Month(CurrentDate()) - Month({Date you want to interrogate}) <= 1 then 1 else " "
Now you can filter on (A) >=0 (B) >=2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what! Not enhancing discovery? It's only been out a short while. I just moved from 1.3.9 was quite happy with that app. What's sac?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.