This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
BrianLewis
Bronze 4
Bronze 4
Since ‎01-20-2023
Tuesday

My Stats

  • 6 Posts
  • 0 Solutions
  • 5 Likes given
  • 1 Likes received

BrianLewis's Bio

Badges BrianLewis Earned

View all badges

Recent Activity

Dynamic measure type

Monday
is it possible to have a dynamic type value as shown in green? I know this format doesn't work, but I was wondering if something like this is even possible. measure: rev {group_label: "KPI Values"label: "rev"type: {% if xxx._parameter_value == 'Stay'...

How to cast a number as string with formatting

Monday
I have a measure sum field and an example value could be $1.45M, but sometimes we need it to say "N/A". My idea was to convert rev to a string and it works, but I lose all the formatting I then tried keeping rev as a number and then create a new meas...

Switch between fields based on selection

2 weeks ago
I have a KPI that shows a sum(measure). I have a field that just says 'N/A'. If someone selects a certain field from a Parameter Selections, I need the KPI measure to change from a measure to that dimension so the KPI will say 'N/A'. How can I get th...

Nested dynamic parameter

11-09-2023
Does anyone know how to nest a parameter? Instead of having a single parameter with 6 values, we want 2 parameters (1 with 3 values and another with 2 values)Gross, Cancelled, and NetBookings, RoomsAnd based on what the person selects (gross, cancell...

how do I fill in nulls in explore?

02-02-2023
I’m doing a left outer join and sure some are not going to be 100% match, hints the left outer, but how do you..or where would you write an if statement to say ‘if null then foo else bar’ in the explore after you do a left outer join?
Likes from
View all