Forum Discussion

Rithik_Prem's avatar
Rithik_Prem
New Contributor III
2 years ago

How to Achieve dynamic data retrieval: Current month + 12 months prior using SQL in Dashboards

Hi All, I am currently facing a challenge with my SQL code in dashboards and would greatly appreciate your help in finding a solution. The issue at hand is that I have hardcoded the code to pull dat...
Dashboards
Parameters
Reports
ckattookaran's avatar
ckattookaran
VIP
2 years ago

Depending on where you are running this SQL query, can't you get the year from the user entry and use a loop to build your SQL query like something similar?

dim strUserTime as String
dim intUserYear as integer = Left(strUserTime,4)
dim intUserPriorYear as integer = intUserYear-1
Dim lstTimeList As new List(of String)
For each i = 1 to 12
  lstTimeList.Add($"{intUserPriorYear}M{i}")
Next

Now you can then do String.Join(", ", lstTimeList), to get the whole list of time. 

  • Rithik_Prem's avatar
    Rithik_Prem
    New Contributor III
    2 years ago

    Hi, 

         I was wondering if you could please elaborate further on the solution you provided.