Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using Ticket-number and shutdown date field I need todetermine how many shutdowns occurredper calendar month from the beginning of2018 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 measureCount({<Yr={">=2018"}>} Ticket_number)You can also use other charts.Hope this helps.