Forum Discussion
Helper IIICreating a fill in table for gaps
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?:
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?:
Helper IIIHello ChrisMendoza,
I am very sorry for the late response but I want to thank you very much for your response. It seems to work but I guess I do not understand how your simple measure actually works. How does it know to key off of "Opened By," especially if I had more columns that it should not key off of, to fill in the gaps?
Thanks Again
- ChrisMendoza
By using the relationship between your 'INC Tickets' table and the 'Calendar' table I am able to ask the question "Is there a transaction that occured on this 'Calendar'[Date]?" If there is not, then the value is zero. Otherwise count the number of rows that occur on this 'Calendar'[Date].
At this point, we're just counting rows, regardless of names (your request to not hard code these values) where transactions are occurring. Since you actually want to see who had transactions you put the filter context [Opened By] into the visual.
Since you didn't have a desired output, I created the easiest to show what you were asking for.
Hope that helps in your understanding.
- TheKiltedGolfer
Thanks again ChrisMendoza for all your help. I believe I do understand what is going on. Have a great day.