Calendar showing dates unavailable

[jakebarr98]

When I select from specific fields(meter name and company), my calendar appears greyed out" for September 2022 and doesn't show the greyed-out dates in the table. However, for other selections where the data is null the date appears in the column (as it should), but the values are null. I have a master calendar, so I'm not sure why the dates show as null with some selections and don't appear for others. Any help appreciated.

[Mark_Little]

Hi,

Would need more information to answer the question fully. But with the Calendar selector it works of the association of the selection made i.e. The is no data on them dates for the dimensions selected thus grey.  Tables can be set up to show nulls and ignore selections so could be where they look different.

[jakebarr98]

Hi Mark,

So I have a pivot table of Meter Name and DateID as rows, and time of day as columns. 

When nothing is filtered, the pivot table shows all dates, even when there is no data available (as 0s in the row)

However when I filter on Account Number or Meter, the pivot table won't show the dates where there is no data. It just skips to the next date where data is available.

I want to be able to show all dates when filtered, including those with no data in.