Hi all, just curious, i was handed an app recently and was required to make a dashboard listing related items as well as a chart for the quantity of the said list… now my question is, is there a way for me to somehow add field [month] and [year] on a chart view type so the chart can show the valid data according to selection, without being in form view? an example below (month and year field is drawn to illustrate end goal)…
Yes i would think you can make an action that shows in the chart (CONTEXT(VIEWTYPE) = CHART or CONTEXT(VIEW) = ViewName) that can change the viewtype. This action can be an Input-action so you can choose the viewtype you’d like. And then base the ShowIF in the view-settings on the value form the Input action. Could that work?
No, there is no way to add input columns to a chart view. Note, however, that the user can use the app’s built-in search and filter feature to filter the data represented in the chart. Alternatively, you could implement your own filtering feature and display both it and the chart at the same time, but that’s a significant amount of work.
Nah that would be like having a chart version and a form version of the same view to facilitate data filtering… which feels like using the normal way of a form and a result viewpage just with extra steps
granted the app’s in-built search function but not useful for my case since example in chart view, the chart doesn’t adjust dynamically based on search to display requested data yes?
Well you would need two or three different chart-views (based on how many different options you want to choose from in the INPUT-action), but it only takes two clicks to change between them…
so… what im understanding from your reply is basically an action button which will then linktoview(), so lets assume my case of 12 months and record within a span of 5 years… i need to have approx 60 views alone excluding range?
I’m not familiar with all your spans and needed options, but remember that you also can base the views on different slices with eg. limited data range. That might help. And I would add a column as enum-text, to INPUT the view options. And then use showIf for the view based on that value.
hmmm all good, i will try to figure something out… thanks for the help though
I would certainly expect it to! It would be easy enough for you to try it.