EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB41779: How to create a date range answered from a single prompt in MicroStrategy Developer


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This article describes how to create a date range answered from a single prompt in MicroStrategy Developer

The user may want to choose a date from a prompt and then have the report dynamically choose a weeks worth of data to view.
If the user chooses 1/15/2010, he should only see data from 1/9/2010-1/15/2010
 

ka04W000001IvzlQAC_0EM440000002Czu.jpeg

 
*With Tutorial Data
1. Create a Value Prompt->"Date and Time"-> Finish
2. Create a report with Date attribute and revenue metric.
3. Create an Attribute Qualification filter with the Date attribute.
Qualify on ID
Operator: Between
Custom: Prompt created in step 1
Custom: (Prompt created in step 1)-6
 

ka04W000001IvzlQAC_0EM440000002D05.jpeg

 
4. Run the report and it will prompt the user to select a date.

ka04W000001IvzlQAC_0EM440000002Czs.jpeg

 
5. After selecting the dates, the report will show data between the date chosen, and the date set in your custom expression at the end of step 3.

ka04W000001IvzlQAC_0EM440000002D03.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

June 8, 2017

Last Updated:

June 30, 2022