Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Have a Line Chart Ignore Parameter Selected

Hello,

 

I am trying to achieve having a line chart that shows the average revenue of the company selected. My only issue is that the two parameters that I have on the top of the report are DATE & COMPANY. Now I want the entire page to load off of the DATE & COMPANY selected, but for the line chart. I want this to just be affected by the COMPANY selected but show all data for all dates. 

 

Basically I am attempting to see the average of the revenue over time in this line chart, while having the rest of the report be filtered to the selected date parameter. 

 

Any help on this would be greatly appreciated.

 

 

Line chart
Need Help
Paginated Report
parameters

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    We can tick the box to use multiple values and get vakues from a  query  in available values.

     

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      I see where you are going with this, my issue is that I want this parameter to only apply to a Line Chart on the paginated report. While the rest of the report works off the parameters that are visible. My knowledge is that the parameter I am creating is hidden, & only applies to the Line Chart in the Chart Properties -> Filters. Any chance you can see if you can make this work?