0

I am trying to do a tabular report

This report is a scoresheet where the rows will be the measurables and the columns will start with this week and go out 13 weeks. 

3 replies

null
    • Nick
    • 6 yrs ago
    • Reported - view

    I've done something similar, but I use weeks for Rows and measurables for columns.

    e.g. Create a new table with 13 records with week numbers. Create calculations for each row you need.

    Row 1 

    let y := Year;
    let w := Week;
    count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 1)

    Row 1 

    let y := Year;
    let w := Week;
    count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 2)

    and so on...

    I hope it helps.

    Nick

    • Nick
    • 6 yrs ago
    • Reported - view

    Update...

    Create calculations for each column you need.

    Column 1 

    let y := Year;
    let w := Week;
    count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 1)

    Column 2 

    let y := Year;
    let w := Week;
    count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 2)

    and so on...

    • nickmassie
    • 6 yrs ago
    • Reported - view

    Thanks for the reply.  Much appreciated

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 1705Views