-
Preset number of Y ticks in advance
Hi, I want to build a line plot in discovery that would have pre-set 5 parts to split into, no matter the data min and max. Meaning, If I have 0 as Mix measure and 100 as Max,…
- Answered
-
Dynamic filter for various slides in the same dashboard
Hi, I want to create a Cube based dashboard with multiple slides. I want to add a country filter for all the slides but each slide it will show just the relevant countries for this specific slide -…
- Answered
-
get a list of unique account_IDs from two lists
Hi, I have 2 lists of Account_IDs, some of them are found within both lists and some are only in one. I want to create a new list with unique account_IDs base on the combination of the two lists.…
- Answered
-
get measure monthly count for last 12 months
I have a [Measure] and that I want to show it's trend on a monthly basis. Therefor I created the following logic: strtomember("[Date].[Calendar].[Date].["+ format(now()-1,"yyyy-MM-dd")+"]").parent.…
- Answered
-
Multi-measure pie charts
I have to measures in percentage that add up to 100% and I want to show in one pie chart both of them. I'm using version 2020.27.113 but it doesn't work for me. Could you please explain how to do it?
- Answered
-
Get data from 2 months ago
Hi, I need to get for a new business logic (AKA formulate section) data dynamically from 2 months ago in order to divide it by data from 1 month ago. I don't have the "2 months ago" filter built-in…
- Answered
-
comment out parts of formulate in business logic
Hi, I'm writing a business logic using a formulate and calculating it based on a calculation of (a+b+c) / (z+x+c+v). I want to check each part on its own to make sure it gives the right output.…
- Answered