I’m running into an issue with the dates getting mixed-up when I load data from Pigment to google sheets (see the formula bar in the screenshot, the date ). The issue is that the title which is a text field appears as the header, and gets translated to a date incorrectly. I tried switching the header in Pigment, but the start/end date fields aren’t listed as options. Did anyone else encounter this? Any suggested solutions?
Currently facing the same issue. The turnaround I found is creating 2 more columns in ‘Month’ dimension. In the first column, reference Month.’End Date’ but the column’s format set as a text. In the second column, use LEFT function to slice first 10 characters, so it leaves only the date. Then, you will have “Date (adj)” (new column containing the date as Text format) as an option to choose for header labels.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.