I want to add a calculated field, which contains a list of strings that can be manually added and modified.
For example, I want to add a field called “Time Slot”, it contains “Morning”, “Afternoon”, “Midnight”.
I saw a similar ask, but the solution still needs to compare with an existing field.
Anyone can help with this? Thank you!
I would like to understand the request a little better. If you create a parameter with multiple values you can use that in the calculated field, as explained in the tagged post. Can you explain your scenario and why multi-valued parameter will not work?
I would love to calculate percentages of each subcategory comparing to total order volumes. But the subcategories may have overlap.
below screenshot shows weekly numbers and percentages of the order volumes that arrived at different timeframes. Column A means if the order arrive < 0 hour comparing to the scheduled time, or arrive < 6 hours comparing to the scheduled time.
In my current dataset, there’s a time bucket to flag if it’s less than 0 or less than 6.
However, the current metrics are counting both <0 and <6 under “Less than 6 hours”, like below:
If I use this field directly, the <6 will only counting the orders that arrive between 0-6 time frame, like below:
So, I want to manually create a string list as a new time bucket, and then calculate them using different formulas.
Perhaps this question is more like how to calculate subsets using a formula like ifelse but allows the subsets overlaps?
Hi @Srikanth_Baheti , I think I found another link to solve my problem. This solution recommends to overlay the views, which works for me. I calculated two different time buckets and overlay the two views.
However, I will still need to add a single column to show as line number in dashboards, like below.
Do you know if there’s any other way to solve this? Thank you!
Hello @danddong, my apologies for the delayed response. If you are still looking for a way to add a RowID within QuickSight, this community topic should give you answer you are looking for!