Calaculation to used as a Dimension

Question & Answer
,
1

Hi! Is there a way/work around of using text result calculation as dimension?

I have bunch of result calculations that are text e.g. Customer but in a tabular visual it’s only allowed to be added to the Value field well.

Thanks!
Benny

2

What are you calculated fields?

For instance I can do a PRE_AGG and place it in the rows section.

sumOver({arrival_timestamp_int},[{client_id}],PRE_AGG)

image
image956×638 66.6 KB

For more information you can look at this blog post.

1 Like
3

Max, here’s the sample

Past Product Owner =
lastValue({Product Owner},[{Product ID} ASC, {Created Date} DESC], [{Product ID}])

4

Yes that calculation won’t be able to be used as a row.

I can mark it as a feature request.