Hello, I have created daily, weekly (between saturdays) and monthly(between ends of the month) breaks to make comparisons between specific days. I would like to know how I could include a cut every 15 days (Day 1 and day 15 of the month). Once I capture the days I use a basic filter with the days that are in the cutoff plus the last date that I have in my data set, for the waterfall graph.
-
First, a parameter was set to pick the date cut wanted: ParCorte
Just in case:
“1) Diario” means Daily.
“2) Semanal” means Weekly.
“3) Mensual” means Monthly. -
This is the calculated field I’ve created so far to get the dates that fall in the breaks:
Corte_Fecha_truncDataVar_Aux
The desired result should include a 15 days cut (“Quincenal”). -
This calculated field is for the graph filter: EsFechaCorteVarAux
-
My current graph:
Thanks in advance for your attention.