How to find Min value for the running Sum?

Question & Answer
, , ,
6

Hi @Vimal, to achieve the minimum value of data for a single day in Amazon QuickSight, you will need to create a calculated field that identifies the minimum value for the day and then use this field in your analysis. Here are the steps to do this:

  1. Create the Dataset: Ensure your dataset includes the date, hour, and data fields.
  2. Create a Calculated Field for Minimum Value: You need to create a calculated field that calculates the minimum value of the data for each day. Here’s how you can do it:a. Go to the analysis where you want to create the calculated field.b. In the Fields list pane, choose + Add, and then choose Add calculated field.c. Name the calculated field, for example, MinValueOfDay.d. Enter the following formula:
minOver({data}, [{day}])
  • {data}: Replace with the actual field name for your data.
  • {day}: Replace with the field name that represents the date, ensuring it does not include the time component.
  1. Use the Calculated Field in Visual: Now you need to create a visual that uses this calculated field.a. Choose the Visualize pane.b. Add a new visual, for example, a scatter plot.c. Drag the day field to the X-Axis.d. Drag the MinValueOfDay calculated field to the Y-Axis.e. Ensure that you have a single point for each day, representing the minimum value of data for that day.
  2. Optional - Filtering for Specific Day: If you want to filter to show the data for a specific day, you can add a filter:a. Choose the filter pane.b. Add a new filter on the day field.c. Set the filter to the specific date you are interested in (e.g., July 24).

These steps will give you a visual that plots the minimum value of data for each day, showing only a single dot for each day’s hours if filtered accordingly.

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

1 Like