Hi Experts, I am migrating one tableau dashboard to Quicksight and in the process i am not able to convert one of the LOD calculations “{fixed :Sum([Count_Total]) }” in Quicksight, where :- [Count_Total] => IF [Field Name]=‘Total_Count’ THEN [Count Populated] END. [Field Name] is a direct string …

Hi royyung, Thank you for your suggestion but i resolved this issue through a custom sql.

Hi @arpitarorait3016 can you provide a sample with data on row level as well as aggregated, to see the expected and actual values? BR

Hi Erik, Please find below the data with required information :- In Tableau In Quicksight Count_Total Count Populated Sum_Count Count_Total Count Populated Sum_Count NULL 72 NULL NULL 72 NULL NULL 58 NULL NULL 58 NULL NULL 43 NULL NULL 43 NULL NULL 61 NULL NUL…

Hi @arpitarorait3016 May be sum(ifelse([Count Populated]<>0,1,0)) may give you the result?

Hi Giridhar, Do you mean sum(ifelse([Count_Total]<>0,1,0))?

Well I guess you seem to be trying to get a count of records in your dataset. Count populated seems to have a value and it having a value can be considered as 1 count. Count total being null does not make sense to use for the calculation

Hi Giridhar, But as per the logic for Sum_Count field it is performing sum of Count_Total field hence if we take the sum of Count Populated it will change the logic itself, thank you!

This looks weird [Count_Total] => IF [Field Name]=‘Total_Count’ THEN [Count Populated] END So, basically there is no data coming from your table where the field name = ‘Total Count’ and hence for all rows where you are showing the Count_Total the value is a NULL. Per say NULL is not counted. If yo…

Hi Giridhar, As we are developing the dashboard in Dev environment so yes as of now all the values we are getting for “Count_Total” is a NULL but the scenario can change in Prod. Can you please provide the quicksight formula based on {fixed :Sum([Count_Total]) } tableau formula where we can convert…

Hi @arpitarorait3016 You could just change your formula for Count Total as follows to get rid of the NULL IF [Field Name]=‘Total_Count’ THEN [Count Populated] ELSE 0 END In your visualization have Count_Total aggregate as Count to get you the desired output. Ideally, I would have considered the …

Hi Giridhar, If i am editing the [Count_Total] formula to “ifelse({field_name} = ‘Total_Count’, {count_populated},0)” then i am getting 0 in “Sum_Count” and if using “ifelse({field_name} = ‘Total_Count’, {count_populated},1)” formula then getting 7876 for “Total_Count” which is a wrong value, i sho…

Not able to convert one Tableau formula

Q&A

Giridhar.Prabhu November 19, 2024, 1:07pm 16

I will need to look at your dataset and analysis.

Please upload to Arena so I can take a look

Topic		Replies	Views
Tableau Fixed equivalent formula in Quick Sight Q&A filters , error , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	3	54	April 17, 2026
Replicate Calculated Fields from Tableau to Quicksight using FIXED LOD Q&A formulas , quick-sight , calculations , Business-Intelligence-Engineer	10	613	January 19, 2024
Transformar un codigo de tableau que contiene SUM({ FIXED YEAR([fecha_entrega]),MONTH([fecha_entrega]),DAY([fecha_entrega]) y SUM({ EXCLUDE Q&A filters , parameters , quick-sight , dashboard , Business-Intelligence-Engineer	1	31	July 15, 2025
Question about calculated field Q&A quick-sight , calculations , Business-Intelligence-Engineer	1	130	April 26, 2024
Coonditional calculation in Quicksight Q&A quick-sight , calculations	9	233	August 8, 2023

Not able to convert one Tableau formula

Related topics