The left table chart ( Account Level Payment) is filtered by the Payment Details (String) parameter, while the right table chart ( Claim Level Payment) is filtered by the Physician (String) parameter. I want to create a third KPI chart ( Total Payments) that sums the values from both tables.
I tried using parameters in the calculated field, but since the parameters are sourced from the dataset, they cover a wide range and don’t have default values. Even when I set defaults, I encounter an error: ‘STRING NOT EQUAL TO STRING LIST.’
Is there an alternative approach I can use to achieve this?
Hi @Abhishek_24,
Could you share the calculated field that you’ve tried setting up so far so that we can see where the error might be occurring?
Also, confirming that all of your data is located within 1 dataset or are you using multiple for the 2 visuals already created?
Hi @Abhishek_24,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial topic?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Hi @Abhishek_24,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.