Problems after press"Refresh data"

Hello Jörg,

based on the info you provide it is hard for me to reproduce the problem. However posting your MashApp is difficult, too, as your webMethods back end data source is not available to me.

MashZone offers two ways to filter for dates the

1. date picker for year/quarter/month selections and
2. date input filed to select days explicitly (when using this make sure its component properties are set to the proper data type)

I assume lost selection states after reloading occur just as one of the data feed results has changed. If there was a list of regions (North, East, West) where North has been selected and the underlying source updates to (East, West, South) the selected state will be lost.

Regards

Stephan

THX for your reply

I must admit that I didn't know the datepicker of the input field. But there are some reasons to create an own calendar:

• the default dates (today or range to the past) should on the screen without userinput
• no filter, because the SQL queries, that deliver the datafeeds should work as fast as possible (parameters with start and end date are pass to the services) and MZ data overflow lurks (over 10000 records) in a full range
• the day of the week should stay on the screen, it is important for the charts explanation to know weekend

I don't know, whether it's clever or not - but it works.

First I've create a Excel sheet with dummy data for one year backwards and an index field.

Then I've created a DF "Kalender".

First the Excel tab 1 with the described data is drilled. An "Information" field provide the today's date.

This is flowing into first column ("Replace Value").

Then "Move Date" is used with direction "Backward" and the Value "Abb" (second col) by day.

For a specified use the date col is copied and converted to data type text.

Our calendar should completed now with the day of week.

On web page of Manfred Wilzeck I've found some top tips to

calculate some important dates and other arithmetics.

On the link "http://manfred.wilzeck.de/Datum_berechnen.html"

there is on part (6) a "easy" calculation of "Day of the week" with the

help of today and some constants. This constants I've parking on tab2 of my Excel file.

This is the second source of my DF. The first source is splitted the date col into cols "Monat" "Jahr" "Tag" and convert it to data type number. The first and second source is combined to calculate the values and the constants. Now we can calculate the day of week and put it into a new col as number. I've add a little round correction, don't know why, but it works.

With a simple replace operation there is finally our day of week in the right col and row.

(0 = Sunday, 1 = Monday..)



How to use this feed now? First little example, Show Date, Time and Day of Week in a

headline of a mash with a refresh of < 1 Minute as a headline of my master view:

Second, to set an input for an interval I use, the DF with Selection boxes to filter charts

or pass parameters to data feeds for xml or SQL queries (passed by webmethods services).

"Abb" you can use the start ranges of select boxes. So, thats all!

regards Jörg