I get the following error message on using ifelse on a calculated metric in quicksight analysis using a parmeter variation. Any ideas on what the issue is ?
1 Like
Hello @rajasrc, I have a few questions about the fields you are using the how you built the aggregate parameter.
Does the aggregate parameter contain a single value and does it have a static default value? A parameter needs to have a default value to be utilized within a calculated field. Also, I am noticing the network field you are using in the calculation is not spelled correctly. Does that match with how the field is spelled in the actual dataset?
Last thing to note, are any of the fields you are using aggregated values or different value types? If network, node, and region are all string fields directly from the dataset, then that shouldn’t be an issue.
With a little more information about the data that you are using in this calculated field, we should be able to find a solution!
Hello @rajasrc, did my previous response help resolve the issue that you are facing? If so, please mark my response as the solution. Otherwise, let me know what other issues you are having and I can guide you further. Thank you!