Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a particular structure for a report using master calendar, like this:
1/1/2015 | 1/2/2015 | 1/3/2015 | 1/4/2015 | 1/5/2015 | 1/6/2015 | 1/7/2015 | 1/8/2015 | |
Client Counts | 5 | 2 | 4 | 2 | 0 | 3 | 6 | 7 |
So i created a Master Calendar linked with my client table using a common date field, also i create a field using this 'Client Count' AS [Client Count], to have all in one row, but i am getting an additional row with an empty field name and showing ceros and null, i want to have all in a single column, not sure why is doing this:
1/1/2015 | 1/2/2015 | 1/3/2015 | 1/4/2015 | 1/5/2015 | 1/6/2015 | 1/7/2015 | 1/8/2015 | |
- | 0 | - | - | 0 | 0 | |||
Client Counts | - | 2 | 4 | - | - | 3 | 6 | 7 |
Measure formula is this:
=Count({$<[Register Date]={"<=$(=EndDTVariable)"},[Register Date]={">=$(=StartDTVariable)"}>}Distinct([Client ID]))
You should probably leave out the field that you created ... as you are doing it double... The expression should suffice. Just make sure that you have the expression/measure as a row and not a column.
The solution was use the month and year to create a month/year field, and use this new field to filter, that worked fine.