Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table, I have added a couple of dimensions and used dimensions as expressions.
I only see blanks in the expression ?
I have checked suppress zeros in the presentation tab of the chart ,it seems to have no effect
You should try with an aggregation function around your dimension.
So on the expressions tab, when you create an expression. Don't just put:
Part_number
but try something like:
Only(Part_number) -> single value
or
concat( distinct Part_number, ',') -> comma delimitted list
Any more info? How exactly you use them. I recommend to use as expressions, for example dimension Account use as:
only(Account)
Thank you for the reply
I use them the way you just mentioned
Dimension name: Part_number
its Part_number in the expression field
Not sure what you mean... Can you upload an example?
You should try with an aggregation function around your dimension.
So on the expressions tab, when you create an expression. Don't just put:
Part_number
but try something like:
Only(Part_number) -> single value
or
concat( distinct Part_number, ',') -> comma delimitted list
The app has sensitive data
Let me put it this way
Lets say I have 10 dimensions
A,B,C,D,E,F,G,H,I,J
Now I create a straight table then use A,B and C as dimensions and rest of the dimensions ( i.e. D,E,F,G,H,I,J) as expressions..note: I'm not using any aggregate functions here the if the name of the dim is D then the epression will have just "D"
Let me know if you near more details
OK, this was how I understood it first. In your example, use expression
only(D)
with label D. Similar for all others.
I tried using only()
for some reason it does not show anything ( I checked in other charts ,they have data in them for this particular selection )
You better upload an example. Scramble data, reduce...
I agree, without seeing the issue, it would be next to impossible to troubleshoot it.