Hi,
I've added a BI query to my VC model. The BI query accepts vendor number as a variable. Once executed, it produces a table of results (1 line per calendar month).
This output is rendered as a graph using the the calendar month as the axis.
However, I want the user to be able to select a range of months to display. The calendar month appears on the BI query as an input not a variable.
If I drag Input and Variable to forms. I get 2 submit buttons and the it seems to ignore the calendar month options.
If I create a new field on the form and attach 1 form to both the variable plug and the input plug on the query, it won't allow month to control the axis !
When I right click on the query and carry out a test, I can enter both the input and the varible, clicking execute brings back the values I want !
Does anyone know how to get around this ?