Data shows in Table but not pivot

Question & Answer
, ,
1

image
image1133×381 15.7 KB

Hello all,

As seen in the picture Comment_check_weekly has 1 for 14th July, but in pivot its not showing this date, but all others, if i set date to weekly level from day it will give the % from 15th not the actual % for 14th. i am using the same columns for both but not sure why its not showing. any suggestions ?

can it be that the week granuarity is starting from Monday? if so how to i change this to Sunday

I have tired 2 different ways in the calculation field. need to check both columns as chance 1 was done but not the other -

/ifelse(isNotNull({title_Weelky}) OR isNotNull({details_Weelky}),1,0)/

ifelse((NOT(isNull({title_Weelky})) OR NOT(isNull({details_Weelky}))),1,0)

Regards
Darren

2

Hi @darresmi,
In regards to changing the start of week. You can achieve that in the Analysis settings section. (see below).
image

image
image295×613 25.8 KB

Let us know if this fixes your issue or if you’re still encountering the same problems and we can explore other options.

Thank you!

1 Like
3

Thank you for the reply, i have checked and seems already set to Sunday.

Would there be any reason the pivot table doesnt pick up the 14th?

i have left joined the information on to the main table. not sure why it doesnt see it when but can view in table format

4

Hi @darresmi,
So are your calculated fields gathering the correct information for other dates, and it’s just the 14th that isn’t working? Or are you not using those calculated fields?
Are you applying any filters to the pivot table that may be limiting your return? Looking at your pivot table, it looks like it’s showing dates that have comment_check_weekly returning a 0 so if the 14th is returning 1, that may be why it’s not showing up.

This may be easier to diagnose further if you are able to create a sample analysis in the QuickSight Arena.
If not, could you provide some additional screenshots so that we can try and learn a bit more on why this may be occurring.

1 Like
5

Hi @darresmi,
It’s been awhile since we last heard from you so wanted to check back in and see if you had any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

6

Hello, this can be closed. issue was because null values in the rows for a column i was referancing. used a different one that had values (was a count calculation).

2 Likes