jlazerus Member

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. 

So I just tried this and SUM is not an option when I do this. I can either COUNT or use No Aggregation. When I applied this with COUNT, it looks like it combines to two values (open, resolved) into the same line on the chart.

I'm sorry if I wasn't clear. What I'm doing on the card is counting the number of `Case Number` and using `Status` as the series. This shows me how many cases were opened each week and of those, which ones are still open and which ones are resolved. What I'm looking to do is to show that '0' are still open for the gaps in…

Table view attached.

Hi Ricardo, I actually tried this on two of my fields but it doesn't seem to change anything on the chart. I tried it on the field being counted in the Y axis and also tried it in the Series.

Sorry Victor. I didn't understand your response until raggaestar said it again lol. Nice job.

I see. That's strange that our properties are different.

I have not set the Hover Text settings. But that is good to know.

Sorry for the delay. I didn't see the reply until now. On the two attachments, if you match up the case numbers, you'll see that the time is off.

Thanks for the reply. I just tried several combinations of what you suggested below at the end of the line but nothing changed. Do I need to write "[\s\S]" just like that or is that a \s or \S? And that goes at the end of the statement? The weird thing that I just noticed is that if I use a regex to replace the 1st line of…

Can this be moved to Dojo Day?