-
1. Re: Tableau - Complicated Trend Graph help needed.
Kathryn Bridges Aug 30, 2016 6:57 AM (in response to Maheshh C K)Hi Maheshh,
Could you post a sample workbook so we can better understand the issue?
Most of this should be able to be solved with parameters.
Parameter 1 should be a list as E1, E2, E2, and then use that to create a calculated field:
"If [Parameter1]="E1" then
If [Period]<=[7/29/2016] and [Period]>=[7/26/2016] then [Period] end
Elseif [Parameter1]="E2" then....
End"
You can also create a DateParameter for "Date Granularity" (Create a list in the Parameter called "Daily", "Monthly", "Quarterly", "Annually), and you'll want to have two calculated fields on this.
The first would be:
Calculation1=
"If [DateParam]=[Frequency] then [Period] else null end"
And then I would take that Calculated Field, and create:
Caluclation2=
"If [DateParam]="Daily" then Day([Period])
elseif [DateParam]="Monthly" then Month([Period])
....
end"
You'll want to put Calculation 2 on the Rows, and then Measurement in the Rows.
You'll have 2 Parameters the User can change, Date Granularity and Entity Name.
Hope this helps!
-
2. Re: Tableau - Complicated Trend Graph help needed.
Tom WAug 30, 2016 7:00 AM (in response to Maheshh C K)
Hi Manesh,
I'll be honest to say that you're more likely to get help if you start to make some progress on this and upload a Tableau Packaged Workbook showing that you've made an effort yourself.
You've indicated that you're new to Tableau (welcome to the community!) so I'll point you to some concepts which should help you get started with your expected output:
-
3. Re: Tableau - Complicated Trend Graph help needed.
Maheshh C K Sep 6, 2016 1:22 AM (in response to Tom W)Thanks Tom & Kathryn. I will work & start a new discussion with the updated doubts.