Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Excel with 22 Columns, in that I need 14 columns to build my chart and one of the 14 columns is my dimension. All the remaining will be used for generating my bar graph.
I tried using Only() for all the columns which I am trying to populate and it's not working.
Any suggestions?
TIA
Only() in your expression will only work if the argument to Only() returns a single value in the aggregation scope (basically the scope of the dimension(s)) using the record set that is filtered by your selections.
If there are more than 1 possible value to be returned, Only() will return NULL.
Then you need to consider another aggregation function.
Try Sum(), Count(), Concat() etc.
13 Excel columns delivering values for a bar chart (one column for one bar each?) sounds like a use case for
hope this helps
regards
Marco
I want everything as a stacked bar chart. As a combination of bar graph and line graph.
TIA
Stacked together.