Comments
-
Just as an update, I also tried sending a single line non-variable string "a,b,c,d" and am still getting that error.
-
Here's a way to split each separation into a row, just in case anyone needs that in the future. select SUBSTRING_INDEX(SUBSTRING_INDEX(Column_Name, '_', numbers.n), '_', -1) name from (select 1 n union all select 2 union all select 3 union all select 4 union all select 5) numbers INNER JOIN tablename on…
-
Still says 'No Data Exists'
-
I just don't want to see 1 on my chart when there are really 0. I don't want to count the null field. I just want it to show as 0 on the chart when it is null.
-
Just to clarify, I'm trying to get a count of the number of distinct system names, even when the field is null. So in those cases, the count would be 0. I did try what you wrote and the error went away, but the chart says 'No data exists'.
-
Valid query, same error.
-
That one says the formula is invalid. I tried it anyway but still get the same error.
-
I get the same error with that.
-
So this worked perfectly for me but now I have a follow-up question. I'm trying to do something similar except there's a series this time instead of just one value. How can I do something similar with a series? See attached example
-
Thanks so much. This is perfect.
-
Is there a plan in place to expand the number of rows that can be shown? I too have a table with less than 1000 rows and get this message.
-
I will give that a try, thanks for the quick reply.
-
Nevermind, I didn't think that out all the way.
-
Did you ever figure out a way to do this?
-
Genius!
-
Thank you for that thread. This one did it. ((.|\n)*)
-
I cannot believe how simple that was. Thank you so much! I really appreciate all the time you put into looking at this.
-
I had to pull some data out of it for security reasons but it wasn't necessary for this chart. The only field I'm looking at is EB Project Risk and I'm using Count as the aggregation for the chart. I'm not using aggregation on the sort. Thanks for helping me out with this!
-
So this is interesting. I did try what you said and it did not work. I even tried creating a brand new card with the same data and it did not work. However what I did notice is that I was given a field for aggregation in the sort menu now. I did make sure it was set to no aggregation but still not having any luck.
-
Screenshot attached.
-
Its a pie chart and I'm counting the number of items in each category.
-
I do not. I don't even have an option for it.
-
So that would be good but I'm using a line chart and I only want them highlighted in one specific drill down filter.
-
That did it! Thanks so much!!!!!
-
Sure thing.