Is it possible to count empty values in a column and replace with some values (i.e., linearly increasing values)

Hi @rkhan , I’ve created an example dashboard that may deliver a solution: [image] The CalcHGM3 calculated field is as follows: ifelse( isNull(avg(HGM3)), rank( [aTimestamp ASC], [avg(HGM3)] ), avg(HGM3) ) Could you test this with your data and check if it solve…

No it didnot. I do not need sum. I want to count cells if less than and equals to (>=) 6 fill with increasing values i.e. if last value was 1, then 2, 3, 4. else delete empty cells

So do you want to count the empty cells or delete them? If you want to delete them then you can filter them out and do a rank. Can you explain more of what you are trying to accomplish, with screen shots of your dataset and what you want the end result to be?

thank you for the reply. I am new to Quick Sight and seeking some guidance.I tried but I might not be doing right statement for the calculated field. I have hourly data which has many(dozens) nan values in many columns excel files. To upload on quick sight I replaced nan with empty cells(otherwise …

for the last part you can use a filter that excludes anything above 12. What type of data is your hourly data column? [image] For your less than 12s… are you saying you’ll have data that’s like this: 1 2 3 empty 5 empty empty 8 And you want it to be 1 2 3 4 5 6 7 8 ? In that ca…

thank you! yes it is something like mentioned. i will be trying this.I just want to add one thing that I have scientific data (sensor data) so no missing time (hrs) but missing observed values. (note: I couldn’t share data due to privacy issues)

Hi,I have a quick question. Can it be done in one calculated field count → if >= 12 → delete , else replace?

It is given me an error. It might be I am not writing it in correct way. Can you tell what is " ? is this inverted commas or for space ’ '? in both cases, it generates error that makes me confuse. Also shows error to fix lag because lag should have 3 arguments not four

The’’ are something that come through on this forum. You should use regular quotes. Can you show me your calculated field? And in regards to the calculated field, a calculated field cannot delete a row. It can be renamed something, to which you then would filter out that value. Hope that helps.

I know calculated field always create a new col. or row. I tried to create calculated field using your line of code but couldn’t saved it. It was given error whenever I tried. I tried using ’ ’ but I was trying to create calculated field using int variable. Also Lag function also generate error eve…

Counting empty cells and replacing with increasing values

Q&A

Max January 3, 2023, 7:47pm 9

yep sounds good! happy to help

Issues with many empty cells (data type: both integer and decimals)

Topic		Replies	Views
Issues with many empty cells (data type: both integer and decimals) Q&A quick-sight	2	592	January 11, 2023
Blank cells (empty) Q&A analysis , quick-sight , Business-Intelligence-Engineer	4	305	December 18, 2023
Dealing with "empty" cells in QS Q&A data-source , quick-sight , data-preparation	8	6194	June 20, 2024
Dealing with "empty" cells on Quicksight Q&A analysis , formatting , quick-sight , calculations , Business-Intelligence-Engineer	3	63	August 23, 2024
Quick Sight Pivot table empty rows question Q&A developer , quick-sight , qls-community	3	92	August 27, 2025

Counting empty cells and replacing with increasing values

Related topics