Alert Table... Link to Months table
MonthsAll Portal ( Code)
MonthsAll Portal Data.... ( Incorrect totals) LAST POST
DashBoard .... Dashboard2 was other test.
Do you have one record in Months for each month of the year?
You have a global field in Months, Active. That means that either all records in the table are active or none of them are active given the global storage specified for this field. That would seem a wrong relationship here given that you are using Active as a match field between MonthsAll and Dashboard. But given the name MonthsAll, I suspect that you want to match any record in Dashboard to all records in Months. If so, you should use the X operator here instead of =. And from what I see here, there is no need to make Active a field with global storage at all. Keep it as a regular, stored calculation field. (Global calculation fields have funky rules for how/when they update so are best not used unless you have a specific need to use them that relies on how those rules work.)
You can tell that your counts are incorrect, but I cannot, I just see numbers displayed with the same field used twice in the portal row.
My best guess is that something isn't right in your relationships linking Months to AlertsPerMonth. If I were you, I'd set up a layout based on Months and put a portal to AlertsPerMonth on it to see what records (and data) actually appear in the portal. Either some fields don't have the correct data, don't have the correct data type or some other detail isn't matching a given record in Months to the correct record in Alerts. Once you can get the correct records to appear in this unfiltered portal, your calculation fields should then start showing the correct counts.
So.. ... Dashboard to MonthsAll ---- DashBoard::FieldDashBoard(NotGlobal) X MOnthsAll::FieldMonthsAll(Notglobal)
FieldDashBoard = "sometextvalue"
FieldMonthsAll = "sometextvalue"
What about the relationship between Months and AlertsPerMonth
Portal not showing one month per row and total are the total for the year in every row...... Should look like
.......an so on
Which portal? The original one on your dashboard or the one in your latest screen shot?
What I see in your latest screen shot, should list every alert for the month of January 2014 to January 31, 2015. I would not expect it to have one row for each month unless you never have more than one record in alerts for each month. This portal is not intended to replace the one on your dashboard but rather to check and see what data your calculation fields in Months are referencing in order to compute their values.
Those seem like the wrong start and end dates for a record in a table called "months" and certainly does not describe the typical "quarter" of a year or fiscal year, but that's the data that I see in your last screen shot.