Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## How to get data in Date-level granularity as user required way

Hi All,

i have below like sample data, when user selects Month from the Month-List box, he wants see that month related-years all months data.

Example:

if user selects "March", and in our data March is having data like March-1990, March-1991, March-1999, March-1995, March-2002, March-2006, March-2011.

Now because of 1990,1991,1999,1995,2002,2006,2011 years have march data, User wants to see all 12-months of data from those years(1990,1991,1999,1995,2002,2006,2011)....

in the same way if User selects April, then April alligned years all months data he wants to see in straight table.

A sample data is given below and also the data attached with this mail.

 ID Training Title Training ID Status Registered Date Training Type 39 Software A-20120 Completed 1/26/2019 ClassRoom 23 Accounts A-11607 Cancelled 12/20/2002 Online 7 Maths A-14448 Waiting 7/23/2008 ClassRoom 11 Medica A-14749 Withdrawn 7/14/2012 Online 27 Social Sciences A-10825 In Progress 7/18/2006 Material 26 Languages A-6609 Completed 8/18/1990 Session 18 Additional Tips A-4629 Cancelled 5/9/2017 Online

Thanks,
Ravi

1 Solution

Accepted Solutions
Specialist

Maybe this

3 Replies
Specialist

Try this

{\$<Month, Year = p(Year) >}

Anonymous
Not applicable
Author

Hi Andrey,

And also user is looking for Online%, ClassRoom%, Session% for the selected month related years of every-month(as per above scenario::

if user selects "March", and in our data March is having data like March-1990, March-1991, March-1999, March-1995, March-2002, March-2006, March-2011.

Now because of 1990,1991,1999,1995,2002,2006,2011 years have march data, User wants to see all 12-months of data from those years(1990,1991,1999,1995,2002,2006,2011).

Can you please add this pivot/straight table to in the same dashboard as per scenario.