I have a dataset with fields such as program ,subprogram,etc… The program field is parameterized, and I have implemented controls for analysis. However, when I create an action to navigate from one sheet to another(uses same parameter in controls), I encounter an error stating: “Your calculated field expression contains invalid syntax. Correct the syntax and try again.” The error code indicates “Contextual_unknown_parameter.” Has anyone experienced this issue before?
Hi @hellosai321,
Are you receiving this error on the page you navigate to or navigate from?
Additionally, for the visual where you’re receiving this error, what is the calculated field you’re using with it?
Hi Brett,
I’m encountering an error after navigating from Sheet1 to Sheet2 and then returning to Sheet1. All visuals that use a parameter field are displaying the same error.
Here’s the calculation I’m using:
(avg(a)+avg(b)+avg(c)+avg(d))/4
This error only occurs during navigation; otherwise, all calculations are functioning properly.
Hi @hellosai321,
Ok, so you have the same parameter control setup on each sheet? Are the visuals on sheet 1 setup to adjust based on the control you’re using to help navigate? Are there other controls on sheet 1 that are setup with relevant values regarding this navigation control?
Could you provide a screenshot of your controls for each sheet along with another one that shows the navigation action you’ve built for this?
Thank you
I have filters applied to each visual for both team and program in all sheets. The controls are the same for both. The action navigation is set up only for the program parameter.
After applying the filter to the entire cross-sheet instead of to each individual sheet, it is now working fine. I’m not sure about the functionality behind this. Thanks!
Hi @hellosai321,
Sounds good, let us know if you have any further issues!