-
Variable List Measure, of a Variable List Measure
Some of our colleagues demo'd a dashboard where they had two parameters, one of which drove the visual i.e. a variable measure. They had 4 groups of measures, profit, reserving, claims and premium.…
- Answered
-
Sankey Chart - Source and Target Same Dimension
Hi I am looking to create a Sankey chart where the source is a month (I want to select a start month using a parameter) and the target is the same month dimension however I want to select an end…
- Answered
-
chart list for development months
hi I have a chart which is showing months 1 to 60+, i was wondering if its possible to show 1 to 24 then from there going in multiples of 3? so 27 30 33 etc...?
- Answered
-
blank row in between different values
Is it possible to add blank rows in the tables? i.e. show 3 value measures, have a blank row then another 3 value measures?? So I have a table which shows increased, reduced, unchanged,…
- Answered
-
Stacked and non stacked chart together
Hi I have four measures, one being premium, and then an set of data of claims split by type, I want to see the premium as one colour in its own bar, and then the 3 claim types stacked together…
- Answered
-
Text to Dynamic Caption
Hi Hopefully an easy one, im looking to add the word "and Prior" to the following dynamic caption text ToString(DateFormat(AddYears(Date(),-2), "YYYY") ) I did think it would be…
- Answered
-
Multi Select (All) parameters
Multi Select (ALL) parameters. If you have this selected to all for a dashboard, after a while new elements are added however the (ALL) selection now only selects the elements which were there when…
- Answered
-
Calculate a dimension value (numeric)
I'm wondering if its possible to use a numerical dimension value in a sum? I have exchange rates in its own dimension table and want to use them to calculate original currency premium value into a…
- Answered
-
Customisable Linear Regression Line Scatter Chat
Hi we have a scatter chart and we are looking to create a line which is Y (Premiums)= X (Claims) so that anything below the line is a loss and anything above the line is profit.…
- Answered
-
Cumulative context but to exclude specific status measures
Good evening I have a report I'm trying to replicate and I've managed to get most of it working but I need to either eliminate two cells as part of a measure or or recalculate the cumulative total…
- Answered
-
Top N - List
Hi We have a list of days which are numeric but not a measure. the values range from 0 to 900. We want to only show the element where they are greater than a specific value set by a continuous…
- Answered
-
Custom sort ordering - order by top N but leave "other" at bottom
Hi I have a table which shows the top N brokers, and then has the rest in an "other" bucket.. this works brilliant but I need to sort by the top N by premium but leave the "other" bucket at the…
- Answered
-
PQL for dynamic text
Hi, I am struggling to write a PQL part for dynamic text to show the last day of the previous month based on current date. is it possible and anyone able to assist? many thanks
- Answered
-
IF formula trouble
I'm trying to do the following: If (Transaction Code = "NWP" OR "GWP",BLANK, (Measure - Amount/ Datapoint - Amount where Transaction Code = GWP)*-1) At moment this is a picture of my formula - I can…
- Answered
Latest Posts
