Craig_Lynch Contributor

essentially it should work like a recursive dataset. By using the output dataset as an input, you bring the data from the last update into the ETL before it's changed. So you take the commentary and join it to the data instead of your webform. Use a Select Columns or Alter Columns before the join to only include the…

Have you tried including the output dataset as an input dataset, then joining the updated column to the appended data?

You don't need "/sites".. Once you select the Drive ID, or the document folder, the relative path is relative to that. So if your main folder you select is "MGMT" Your relative path would be "/Equipment"

Hi Kim, Maybe there's something to this that I'm missing, but the Distinct would be causing the grand total to only sum the unique values within the list. By having the Position ID displayed, you should just be able to aggregate(sum) the Fee column and it would give you the result you're after.

Totally agree with this! I love the Flex Table chart but, for the same reasons I end up using other cards. Also should enable 100% fill chart type as a selection. Possibly even html?

@cadellfalconer it's via the drop down menu and clicking Export to. Apologies for the delay, notification wasn't received.

Using a filter like that would restrict the data to only the week selected and exclude it from the weeks that you're trying to compare to. You'd need to group everything in two week blocks to use a filter like that, or a better option could be to investigate the use of variables or segments.

Agree, this is a required option. Whilst the PDP option is technically doable, it's more of a workaround to address this issue, and as OP says, it's a huge job to not only go back and apply PDP to every single dataset, you would then need a group for every dataset, and someone to manage those groups. When sharing a…

Definitely need this.

Strongly support this, option to remove abbreviations should be available on all cards. Especially when you look at a Filled Gauge (has option) vs Radial (doesn't have option), sometimes forced to use filled gauge because the abbreviations aren't appropriate.