Help Needed: Data Feed not pulling entire query spreadsheet report value

Workaround: In your ARIS Architect Query -> Spreadsheet create a new column with the formula "=TO_STRING(X2)" (potentially adjust the cell reference, it should point to the cell where you use the "=QUERY_ATTRIBUTE_VALUE(...)" function for the Man hours).

Then re-generate the Dashboard-Link with the included new column.

In the Data Feed with the updated link you should see a new column that contains both the amount and unit as text. You can use string manipulation operators (find first space, substring to/from space into new column) to separate them into different columns if desired.

Alternatively you can also turn your original "=QUERY_ATTRIBUTE_VALUE(...)" into a "=TO_STRING(QUERY_ATTRIBUTE_VALUE(...))" if you don't want a new column.

Hi Kay,

You are a rockstar! Appreciate your help. It worked. :)