topic Re: Calendar showing dates unavailable in App Development

Calendar showing dates unavailable

jakebarr98 — Tue, 02 May 2023 10:37:57 GMT

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.

Re: Calendar showing dates unavailable

Mark_Little — Tue, 02 May 2023 10:58:07 GMT

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.

Re: Calendar showing dates unavailable

jakebarr98 — Tue, 02 May 2023 11:33:50 GMT

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.