Hello Experts,
While I am using periodOverPeriodLastValue I am getting error: TABLE CALUCLATION ATTRIBUTES ARE MISSING and VISUAL_CALC_REFERENCE_MISSING.
Dataset : Test.xlsx
I have Date field, Two KPI Cards,
For One KPI Card: Count ({UniqueKey)}
Second KPI Card: periodOverPeriodLastValue(count(UniqueKey),Date,MONTH,1)
but for periodOverPeriodLastValue i am getting error CALUCLATION ATTRIBUTES ARE MISSING and VISUAL_CALC_REFERENCE_MISSING.
Anyone, Please help.
Thank you!
Error and Data format for reference
Is Date a field in your dataset? That seems to be the issue,
Yes, Data a field in my dataset. You can find it under Dataset Image.
So How Should I resolve it?
Thank you so much for your quick help!
May I know the formula you’re using for PreviousValue?
On a separate note:
When I apply a date filter range (e.g., 01-Feb-2025 to 28-Feb-2025), I only see the count for the selected date range. However, the previous month’s count is not displayed.
If no date filter is applied, the maximum month count available in the dataset is displayed.
Is there any way to make it work such that when a date range is selected in the filter, the previous month’s count is also displayed?
Thank you in advance for your assistance!
When you filter the visual you loose visibility to the previous period in the visual. To meet your requirement you will have to create two mesaures a) Current Value b. Previous Value which compute the data by filtering dates in the calculation. Don’t filter hte visual itself
Referece:
Example:
Please keep in mind that filtering is by specific dates which could be tricky as in the example above where Feb has 28 dates; previous period is filtering Jan 1 to 28. If you are keen to filter by specific time frames (Week, Month) you can change the parameter to specify start date and Time Frame (Week, Month ) etc and modify the calculated fields accordingly.
Thank you so much for your help! Much Appreciated.
