Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 4 columns consisting of 32 rows each. I need all of these values to be populated on a Bar chart. I have tried using Only(column_name), but it says 'No data to display'. Is there something I am missing here? How can I populate the values of all the rows of the 4 columns?
TIA
What is within those columns? Can you share few rows of data for the four columns? Also why use Only(), do you have all those 32 rows as the same number? May be use Max or Min or Sum or Avg?
This is how the data looks(part of it)
0 | 0 | 2 | 0 |
0 | 0 | 0 | 2 |
0 | 0 | 0 | 0 |
0 | 0 | 4 | 0 |
0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 |
Have you tried Sum(Column_Name)
We only need the bar chart to be populated with the values. Not based on the Sum of the values.
Hi try this
Rangesum(column1,column2,column3,column4)
Nope, Not working.
I do not want any type of Sum. I just want to populate my chart based on the values.
Hi,
sum(Aggr(sum({<column_name={'*'}>}column_name1),column_name))
What is your dimension here? Or do you not have a dimension? If you don't then this isn't going to work.
May be create a dimension when loading the data
LOAD RowNo() as Dim,
Column_Name1,
Column_Name2,
Column_Name3,
Column_Name4
From ....;
And then use Dim as your dimension and Only(Column_Name1) as expression
Hello,
I am not looking for any type of Sum formula/expression to populate the chart. I just want to populate based on the values.