I have a Utilization table that shows the percentage of hours our employees have logged divided by the total hours possible. This table shows the utilization rate per month for the past 12 months. When I add filters to show just one month, it shows the correct amount based on my calculations from th…

solved it by doing Min(Pentesting Hours + Support Hours)/Min(Billable Hours). Closing out.

Hi @doneliza and welcome to the Quick Sight community! I wonder if when you expand the filter range, it’s affecting your calculation. Could you either share the calculated field that you’re using for this instance or upload your analysis to Arena so that we can view how your data is being affected. …

It’s( (working hours + support hours))/((# of workers x 168)-(PTO Hours))

Could we do a call or is there office hours I could be signed up for? I’m not sure if Arena would work with some of the data being relatively high confidentiality.

Hi @doneliza , Totally understand, unfortunately there’s no call in option for community. Maybe we can work around this if you share some screenshots instead and black out the confidential information portions. Ideally, a picture of the visual, the values being used for the visuals and the filters a…

[image] - with relative dates filter [image]

[image] with the full year and filter adjusted - [image]

Included screenshots of the filters and different amounts. The first is correct. The second is inflated. Please let me know if you have any thoughts. Thanks!

Thanks for sharing @doneliza ! Is the calculated field you sent yesterday being used for pentesting hours? It could be helpful to see that calc. field as well. My initial thought is that you will want to try utilizing LAC-W aggregations and create a month date field with truncDate to ensure you are…

No sorry this is the calculated field for pentest hours; sumIf(hrs, {hour type: name}=“Task Time” AND (project<>“Pentest Support Schedule”) AND ({hour type: name}<>“Non Pentest Time”)) Should it be sumOver rather then sumif? So yes exactly. That’s what we can’t figure out. When we go through the …

Potential Bug

Q&A

Brett July 9, 2024, 3:47pm 4

Hi @doneliza,
Thank you for sharing! I think it will be a bit easier to assist through Arena so that I can see how your filter is setup and how the table is reacting!

Topic		Replies	Views
Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc) Technical Articles yoy , date , period-over-period , quick-sight , calculations , Business-Intelligence-Engineer	103	38103	November 24, 2025
Equivalent to the relational model Q&A analysis , calculation , calculations-editor , calculated-field , quick-sight , dataset , calculations , Business-Intelligence-Engineer	5	134	June 7, 2024
Creating period comparisons with Quick Sight's periodOver and periodTo functions Technical Articles error , calculations	32	25287	November 21, 2024
進捗率100％の完了案件を除いた累計と月次合計を表示する方法日本語で質問 \| Q&A filters , quick-sight , pivot-table , Business-Intelligence-Engineer , Japanese	9	231	April 16, 2025
Distinct_count(dimension or measure, [group-by level]) が想定どおりに動かない。日本語で質問 \| Q&A filters , quick-sight , calculations , Business-Intelligence-Engineer , tables , Japanese	3	381	January 6, 2024

Potential Bug

Related topics