I have created a table visual with current month and previous month deposits using `periodOverPeriodValue().
and also table shows all month’s data but i dont want like that.
Currentmonth SPLM
8139551 20470114
how to hide remain .
What am I missing? I want to display April 1 to 5 if I select May 1 to 5, and similarly, if I select April, it should show March’s deposits. Please suggest.
TIA
Hi @swapna and welcome to the QuickSight community!
Are you also using any type of filter or control to handle the dates being shown in your visual?
Also, could you share the calculated field you put together with periodoverperiodvalue? Are you receiving an error when trying to build that calc. field or is it providing the incorrect information?
Something else to consider in a scenario like this would be to include the usage of addDateTime function. This can be used to help assign the date fields that should be included in the calculation.
Hi @Brett Thanks for reply,
yes iam using parameter as Date, month and year as control and also, Date(period) used for filter .
Not getting any errors while build calc field.
Date(period):
ifelse(
${PeriodStarting}=‘Day’,truncDate(“DD”,{activity_date}),
${PeriodStarting}=‘Month’,truncDate(“MM”,{activity_date}),
truncDate(“YYYY”,{activity_date}))
activity_date(YYYY-MM-DD) is the date column in my dataset.
periodOverPeriodLastValue:
periodOverPeriodLastValue(sum({deposit_success_base}),{Date (Period)},MONTH,1)
Hi @swapna,
What dates do you have selected for the screenshot you shared in original post? Basically, what are you selecting and what are you receiving?
Do you get correct results from running any of your parameter options?
If you have ‘year’ selected in your parameter, how would you expect the result to return if using MONTH in your periodoverperiod calculation?
My thoughts are that it has something to do with that, you may have to add an ifelse in there to account for each parameter option when runnig your periodoverperiod
