Hi,
I am working for an Indian Client where they want to see data points in Indian numeric system i.e Crore, lakhs instead of Millions or Billions
Have done something similar in Power BI
But facing challenge in replicating the same in Quicksight since ifelse condition is numeric while its output is string hence below written KPI doesnt work.
Hi @shweta,
When you want to use static Strings within a calculated function, they have to be quoted using ". If you change your logic to the following, the error should disappear:
Hi @shweta,
I assume that you tried to use the visual type KPI to display the result of your calculated field (please let me know if this assumption is inaccurate). The KPI visual works on top of numeric values. If dimensional fields are selected, the COUNT aggregate function is applied to create numeric values. Also in your case, the result of your calculated field is a string and no numeric value and, hence, the visual type KPI does no longer work to visualize the result of it. Instead you could simply use for example visual type Table and remove all header information and non-desired formatting from it to simply display the aggregated value and title within the visual.
I hope my solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking his answer as a “Solution”.