Running Avg - Missing weeks in table

Q&A
, ,
1

Hi, I have shared screen grab of table below. In this case dataset does not have data for few weeks which should be considered as 1 and running Avg needs to be calculated including the missing weeks.

image
image193×452 8.1 KB

Col1 - Week No
Col2 - RFQ %
Ex: Col 3 - Row 9 value should be running avg (Including missing week no ) = 8.33 / 9

Can you please provide solution ?

Thanks

2

Hi @smisquit,

QuickSight does not have a function or feature that provides the ability to fill in empty gaps within your data; at least not in a scenario like your ‘week no’ field. You would need to edit your dataset to include the gaps in week no’s.
If you had every week no, you could build an ifelse statement with the isNull function; which will allow you to replace empty fields with a value of your choice, like 1.

Let me know if you have any additional questions!

3

Hi @smisquit

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!