Hi all I need assistance for a hourly dashboard to create calculated field
I have Past 4 weeks hourly actual data the calculation field should averaging the historical % share for a given FC, weekday and hour. and is it possible to have an option for manually excluding any week in past 4 weeks calculation.
@S_GOWTHASHYAMOULI it would be helpful to have few lines of data (5-8 rows) to understand what you want to build, you can always filter data including weeks using filter controls
We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.
As Show in the Pic I have Date, hour,day of week, FC, metric and Values, based on this Im trying to create a forecast using Past 4 week historicals For example i have 24 hours data i will consider sum of 24 hours = 100% and will get values of houly % by that hourvalues/ sum ( 24 hour values) = % of that hour . Next step is to average the past 4 weeks values over day of week,hour,fc, and metric which i tried to do in 2 ways 1. (avgOver(sum({Forecast_R}),[dow,hour,metric,fc])) - reslut is same % hour 2.sumOver({Forecast_R},[dow,hour,metric,fc]) / countOver({Forecast_R}[dow,date]) showing error
Hello @S_GOWTHASHYAMOULI !
Are you still running into this issue? My recommendation is to first try breaking out some of the partition fields you are using in your LAC calculations as filters. This will at least help isolate the error. Also, it might be better to use the same function for both rather than sumOver and countOver.
I am going to archive this topic since it has been open for an extended period of time. If you would still like assistance with this, or if you have a new QuickSight question, feel free to post a new topic in the community so you will be at the top of the priority list for a response from one of our
QuickSight experts. Thank you!