Hi All,
I am a new user to Tableau and am completely stuck on how to run a calculated field.
I need to calculate a # Sales / # of Records
I have done this with the above formula and it works as long as there is only 2 dimensions:
Group 1: # Sales # Records %Conversion Rate
Group 2: # Sales # Records %Conversion Rate
My calculated field works in the above scenario
If I add a filter of a month or so to the view then the whole calcualtion changes but I need the #Records to remain the same for the conversion calculation to be correct.
How would I create a static field? Or how can i have all of these calculations in one palce, so the table ends up looking something like this:
Group | #Sales | #Records | Conversion Rate | Month |
---|---|---|---|---|
Group 1 | 100 | 1000 | 10% | |
Group 1 | 20 | 1000 | 2% | March |
Group 2 | 30 | 1000 | 3% | April |
Thank you so much in advance
Sorry I am really finding difficult to understand your question completely but here is my response based on what I understand.
You can create two calculated fields.
1) Create a calc field and enter 1000 with calc name Record.
2) Next create cal field as sum([#Sales])/Sum([Records]).
The Record field would be static and also the 2nd calculation should meet your requriement. Let me know if this works.
Thanks,
Loga