ActiveSQL, Crosstab Table - First Day of the Week - All version 14

Steve Jarvis

• October 24, 2022 16:01
• Edited

I have just Discovered that when creating a Crosstab Table in Anaylsis Grid while using ActiveSQL, does not conform to the "First Day Of Week" rule in _Settings, well at least for me.

I have run Analysis Grid, set date range using a week starting date of a Monday and set the End Date to a Saturday date, 4 week range for testing. Aggregate - sum, group by week, data looks good. However, when I add a Crosstab Table the start date is Saturday so i end up with a single day at the end of a chart.

I tested the same Analysis Grid using Datalayer and everything looks good. I also retested in another application both on my laptop and the server with the same results. Fellback to 14.1.051 and it looks OK.

Also I notice the date range for the last date cannot be set.

I wanted to confirm if anyone else see the same before opening a ticket.

Thanks,
Steve

0

• 

  Steve Jarvis

  • October 24, 2022 16:02

  This has been passed on to Engineering as a problem since this affects all versions of Logi Info Studio, at least the ones I have available.

  0

Please sign in to leave a comment.