har_d_har1 Member

@MichelleH The data will be used to generate a card like this. What I have going in are start and end dates of various activities, and a total amount of effort to complete the activity. I'll want to display each activity in its own row in the chart. I'm aware of the issues with removing/adding table columns via ETL, so I…

@GrantSmith I have since realised that my code is changing the schema and that this is the cause of the error (duh). Rather than update the schema daily, which introduces more potential for errors (I am not a smart man) I have worked around this issue by sticking to a static start date of 1st January. Then the schema only…

To workaround this issue and allow by ETL to complete, I have created a separate ETL dataflow just to produce a table of columns from the Domo Dimensions Calendar, which I then use as an Input DataSet to the above code, essentially removing rows 11-30 above.

Dynamic PDP solved this - my organization only uses one Trusted Attribute, which wasn't well represented in my input datasets. Once I figured that out it came together easily.