Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using Ticket-number and shutdown date field I need to
determine how many shutdowns occurred
per calendar month from the beginning of
2018 to present run date of report
In your load statement include the following;
LOAD
Ticket_number,
[shutdown date],
Year([shutdown date]) AS Yr,
Date([shutdown date], 'YYYY MMM') AS YrMonth
......
On a Straight table have, YrMonth as dimension and this expression as measure
Count({<Yr={">=2018"}>} Ticket_number)
You can also use other charts.
Hope this helps.