Forum Discussion
TheKiltedGolfer
Helper III
Helper IIICreating a fill in table for gaps
I am trying to create a table, with continuous calendar dates, showing the total number of tickets opened per day per associate. Sometimes a specific associate will not open a ticket for or day or e...
With a proper date calendar table 'dCalendar' you could take 'dCalendar' [Date] into a table visual and choose Show items with no data like the below image.
Maybe a simple measure like
# Open Tickets = IF( ISEMPTY('INC Tickets'), 0, COUNTROWS('INC Tickets') )will yield :
but this seems rather difficult to read and if I actually had a full calendar the scroll would last forever.
Putting into a Matrix visual may be a better option?:
ChrisMendoza
Resident Rockstar
Resident Rockstar
With a proper date calendar table 'dCalendar' you could take 'dCalendar' [Date] into a table visual and choose Show items with no data like the below image.
Maybe a simple measure like
# Open Tickets =
IF(
ISEMPTY('INC Tickets'),
0,
COUNTROWS('INC Tickets')
)will yield :
but this seems rather difficult to read and if I actually had a full calendar the scroll would last forever.
Putting into a Matrix visual may be a better option?: