I created six constituencies on Thursday and added them to a custom category in TX_ANALYTICS_DIVISION_ELEMENT but only five of them are showing up now.
I set the constituencies up to run daily overnight and update records, which is happening and I can see the constituencies on records. I can also run a sql query in the analytics data warehouse and find records that have the new constituencies but when I create a widget, I only have options for five of the six under the custom category. The full load ran last night so I don't think that's the issue. Has anyone else experienced this? Am I overlooked something in my troubleshooting or set up?
Thanks!
Hi Melissa,
Is it possible that the constituents associated with the sixth constituency do not have data in the cube you're using to review the constituencies? For example, if that sixth bucket is of people who do not have contributions, but the review you're doing is in the Contributions cube, then they won't be in there. You could also try filtering a new dashboard on a single Constituent ID you know to have the constituency that isn't showing up in your widget, and then confirm whether they have any data in the cube you're using for the review.
Best,Chris
The constituency is looking at renewing subs and I'm using the Seats and Tickets cube. I took your advice and created a new dashboard in Seats and Tickets and filtered on a single person who has the 1920 and 2021 constituency on their record but only the 1920 is showing in the widget. But I think I figured it out. If a record has a renewing const for 1920 and 2021, my sql is ignoring the 2021 constituency and just picking 1920 if they are both renewal types.