Turning into Analytics App -- Input End Dates

I have the following Analytic app -- but its not capturing the value that I want. For example , the End USer will just need to enter the Date they want to see . For example, if I want to capture just 12/31/20 -- I just want to see that data measure -- however, its listing all data output. Please advise.

CHeck Report End DAte.yxwz

Date Time

Common Use Cases

Accepted answers

apathetichell

Yes - I see it looks wonderful but there's a problem.

Here is the formula in filter:

"2021-12-31" = [Reporting Date]

Here is what it says in the action updating that filter:

2020-12-30

If those two numbers don't match it will not work.

Here is the corrected action tool.

CHeck Report End DAte FIXED.yxwz

ll98

@apathetichell Got it -- Missed "Replace Specific String' option at the bottom

Since at the moment capturing "2020-12-30" = [Reporting Date]

If I want to capture all balance up 2020-12-30 - -Do I need to do the filter as "2020-12-30"<= [Reporting Date]

All comments

apathetichell

Hi,

as set up your action tool wasn't updating anything - you want it to update one of the two dates in your filter. I set up one of your dates to be hardcoded to make it clearer what you were updating. Then I set the action tool on replace string and chose the date that I hard coded in as the text that I wanted to replace.

In addition, I went into interface designer to make sure your browse tool was selected to output after running the app.

CHeck Report End DAte.yxwz

ll98

@apathetichell -- from the End User perspective -- I want just to input the date and get the value based on the date --- i.e. So if I pick 6/30/2020 -- I just want to see the value for that day.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703