Creating a dynamic constant metric using prompts

Hello there,

Sometimes we need to create a constant to compare some numbers with this constants.



And in this case, this constant can be changed by the user.

To create a dynamic constant you can use this simple example:

  1. Create a numeric prompt and name it as promptTest
  2. Create a derived metric as Constant Metric in your report like:Max(?[promptTest]) {~+}
  3. Create the case metric like this: case(profit < [Constant Metric], 1,0)

Now you have a dynamic constant prompt metric.

I hope it helps.

God bless you

7 thoughts on “Creating a dynamic constant metric using prompts

  1. Alex

    I’m not certain the place you are getting your information, but great topic. I must spend a while finding out more or figuring out more. Thanks for great info I was in search of this info for my mission.


  2. Alex

    You could definitely see your skills within the work you write. The world hopes for more passionate writers such as you who aren’t afraid to mention how they believe. All the time follow your heart.


  3. Carey Glenn

    Valuable info. Lucky me I found your website by accident, and I am shocked why this coincidence did not happened earlier! I bookmarked it.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s