Hello friends-
I'm using a dashboard for first time attendees that I got from another thread. Worked great in my last job. Here in new job, it works great in test for some reason, but I can't get it to work in live. I get this error. Is there an easy fix on this? Having two tables not connected in the ElastiCube sounds perilous.
Hi Will. That is odd but looking at the .dash file I could see it could happen. I'm assuming that this widget (if not the whole dashboard) uses the SEATS AND TICKETS cube.
Maybe the PERFORMANCE DATE is from Seats and Tickets cube and CONSTITUENT ID is referencing another Cube from the same widget.
Can you open the widget to find the constituent ID value and replace it with constituent ID from the Seats and Tickets Elasitcube?
NB/ There is an alternative by replacing the datasource for the field in the javascript of the .dash file (not as scary as it sounds) by finding the address you want in a dashboard you know works. Then opening the .Dash in Notepad++ and changing it there. ... that's for another day though.
Hello Heath-Thanks very much for that! A great thought. I tested it out. I think I'm using the right constituent id in Seats and Tickets Elasticube. I think the problem is the performance date. I went back in and tried to replace it from performance date in the seats and tickets elasticube, and still got no results. I've been testing various "performance dates" that I can find. But when I search the data browser for performance date or constituency or anything else, I thought that if the field came up, it meant that it was in that Seats and Tickets cube, and it would work. Maybe that's not the case.