Actually, I have some special needs with column charts. May be someone can tell me that this is not possible, or tell me how I could achieve this.
1. Couldn't find a way to select a certain column in a column chart with the start of a MashApp or automatically select a certain column by an action on a MashApp, without clicking on the column. I don't mean to enter a default value, since the selected column is not always the same. Actually it depends on the current time.
2. Also couldn't find a way to select all columns of a column chart under the same conditions than under 1. .
Example:
At the start of the MashApp I want to select column 04 in the first column chart, since the current hour is 4. And I want to select all columns in the second column chart, since I want to cover the time from 4:00:00 to 4:59:59.
Actually, I am not sure what your intention is. Maybe there are other ways to solve it.
Default selection must be based on a constant. As of today there is no way to calculate this. But a similar question has been asked before. In the next version of MashZone you may specify the selected column "from outside", i.e. using a URL parameter you can select which value to select by default.
The other question's answer is short. In MashZone there is only single value selection per chart. So, you cannot select multiple columns at once.
However, the selected hour could still be used in a slightly different comparison. For instance, to filter the transaction list in a way which selects only transactions that happened before...
Is it an option to utilize the slider? Instead of clicking the column chart you could slide to the hour. As a result the transaction list on the bottom filters and the column chart could be updated, too.
One final remark: In the next version the default of a user input field can be bound to a data feed. So defaults (current time) could be calculated.
Regards
Stephan
Thank you Stephan!
I don't know if I can use a URL parameter to select one of my hour columns. I guess not, but I have a try. I know about the default selection based on a constant. In my case I have 24 columns (00-23) and I want to preselect the column of the current hour. The current hour I get from the today's date of an input box. When I start the MashApp at e.g. 11:21, the current hour is 11. I have the value in a data feed. I would want to bring this variable value to the initial selection field.
Ok, multiple selection is not possible.
To output all transaction, which happened before a time selection is not an option for me I think. I expect rather many transactions (could be 10000 in a second), so that I think I have to select small pieces of time.
When I have a slider with 0-23 I cannot preselect one hour either, can I? When I have a slider and a column chart, I need too much space. And the header of the column chart is already used. May be I have to do some more exercises with a slider.
Yes, thanks for the current day/time as default in a user input field. I will try it in the next version.
Indeed. As of today, you need to provide a customized input to select hour and minute. You could add two combo boxes to select them. If both had an additional row "current" you could default to now.
E.g. a two column feed like this
.PNG)
and the feed's contents like that
.PNG)
enabled you to to default to current hour.
Regards
Stephan
