@Gianni Ceresa Oracle Analytics Desktop May2024

@Christian Berg -Oracle Service Count is a number but Service Type is a string. I have them both as measure with count aggregation. i tracked the root cause and it was the calculation. i also tried to analyze the issue in calculation but it is so simple and i couldn't find it thank you for your assistance

@Gianni Ceresa Thank you very much for your thorough response, Yes, i want column "Service Count" to only show values for those 2 service types or show 0 instead. I did a CASE WHEN calculation as you advised but when i drag it to visualization i get query error: Error during query processing (SQLExecDirectW). State: HY000.…

@BalagurunathanBagavathy-Oracle Sorry for my ignorance but what is "level-based measures in the RPD"? I'm completely new to working with SQL and analytics and i use Oracle Analytics Desktop my main reference is and it is very general and not in depth

@BalagurunathanBagavathy-Oracle even with keyword END the outcome remains the same

@SteveF-Oracle apologies, here's a screenshot

@BalagurunathanBagavathy-Oracle It looks okay CASE WHEN XSA('weblogic'.'BI_Daily Visits')."V_BI_DIALY_VISITS"."Service Type" = 'Free Consultation' THEN XSA('weblogic'.'BI_Daily Visits')."V_BI_DIALY_VISITS"."Service Count" WHEN XSA('weblogic'.'BI_Daily Visits')."V_BI_DIALY_VISITS"."Service Type" = 'Paid Consultation' THEN…