To group Monday to Sunday, you would need a separate numeric field. It so happens that the numbers Panorama uses internally to represent dates are divisible by 7 on Mondays, so you would fill that numeric field with
Date\7
where Date is your date field. For weeks that start on Tuesday you would use (Date-1)\7 etc. Then you would just group on the numeric field.
FYI, I’ve made the changes so that Panorama X will honor the system preferences for the first day of the week. This affects grouping and the week1st( function. There is also a new firstdayofweek( function. Look for these changes when the next version of Panorama X is released.
I still have problem with comma as decimal separator:
“copy” from excel datasheet, one column 12,34
2." import" to panx database, “from clipboard” two columns 12 and 34
so the comma does not function as decimal separator
I don’t have a copy of Excel, so I can’t try this. But I imagine that if you pasted the text into a text editor like BBEdit or Text Edit, it would look like this:
There is no setting in the world that can allow Panorama (or any other program) to recognize that the last comma is part of a number, instead of a field separator. This is really a bug in Excel. According to the CSV standard, they must put quotes around any data value that has commas in it. Since they haven’t, there is no way for Panorama to properly parse this. You should submit this bug to Microsoft.
I tried it with Excel. When I pasted into a text editor, there were tabs separating the fields. The only comma was in -7,20. It looks like the wizard is treating both the tabs and the comma as field separators, rather than just the tabs.