Are you trying to represent 0 values (including those of your bullet graph) on a logarithmic scale? log(<=0) does not have real values, which may be the reason you're seeing this error.
A possible fix would be to filter out all 0 values prior to rendering, or to give 0 values a non-zero value.
Is it possible to include a twbx?
The main plot uses the Count of the inspections. Using Sum renders the same results as Count though.
I am basically showing how many inspections each inspector has performed each year. The client has asked for the median value to be represented on the graph.
Does that help?
Thanks for your response. That makes a lot of sense about the Zero values.
How would one go about filtering out those values before rendering the graph?
I would need to create some dummy data to include a toolbox which I don't quite have time to do. If i find a minute, I will try to upload something for you. But if its possible to find a solution without it, I would be forever grateful! (I know that's a huge ask from the community, I'm sorry!)
That is not the problem. It actually has nothing to do with the Median value. The problem is that the logarithmic axis creates an error when a filter is used to and all the options in the filter are deselected.
I didn't have that problem in the example I made - the only problem I ran into was when I mixed take the median on the ref line of values that were aggregated as median
Just taking the median on the sum of the values allowed use All in the filter values or filtering then going back to ALL
if you post your book I'll look at what is going on
I have edited the post to include a .twbx so that you can see the error in action.
Go to the dashboard and click the 'All' button on one of the filters.
I have attached a .twbx to the original post so you can see what happens.
I looked at it and don't have an answer - I can not reproduce the problem with other workbooks
I see you took out a support ticket - have you heard anything at all?
Also did you mark the ticket as keeping you from doing your job?
Yeah, its a complex error that I don't think many other people have found.
The support team helped me to isolate that it is the logarithmic scale that causes the issues. They said that they have filed a report with the development team to take a look at it and will let me know if there are updates, however, in the mean time, I should just avoid using the logarithmic scale.
That's why I'm trying to find a way around it.
I can't exactly remember what I marked it as but I am sure I would've said something like that.
you could just plot the log(count(number of records) hid the axis and put the count of the records in a tooltip or on marks