Turning into Analytics App -- Input End Dates

[ll98]

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.

[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.

[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.   

[apathetichell]

That's how it's working on my system. Was there some data that you didn't want included? When I click on 6/30/2020 I get the info for that date.

Note - with the limited amount of dates to choose from you may want to use a drop down instead of a date interface.

[ll98]

Are you running from the Analytics App -- and picking the date --- cause when it executes it just shows the date on the custom filter - I'm picking 6/30/2020

[apathetichell]

This is what I get when I pick 6/30/2020 on the version I uploaded.

VCID GL Account Amount Batch GL Date End Date Reporting Date
10017 8400 - Administration Fees 47004.57 6/30/2020 2020-06-30 2020-06-30

Is that what you want?

Could be too many files with the same name.

[apathetichell]

FYI - on the version you uploaded the specific string to replace in the action tool should be:

2020-12-31

It's 2020-12-30.

Once that is fixed your app should work very well. basically right now it's trying to replace a string that doesn't exist in the filter tool so the filter tool is just running as though no replacement occurs.

[ll98]

@apathetichell   - I simplify the input table  --- So when I run it as an App -- I pick the DATE as 6/30/2021 -- but it still produces the output of 12/30/2021..

Look at the WF attached... 

[apathetichell · Accepted solution]

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.

[ll98 · Accepted solution]

@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]