The client has the following report structure - one example as shown below,
Number of Reports received Q1/Q2/Q3/Q4 - 10/20/30/40
Can I create similar kind of report in Tableau. I tried creating a calculated field but its showing the result value of 10/20/30/40.
Is there any way to show the numbers as such??
Assuming the number of reports for each quarter is a measure names in the format No_Q<x>_Reports, you can try to create a calculated field (let's call it #Reports) like this:
str([No_Q1_Reports]) + "/ " + str([No_Q2_Reports) + "/" + str([No_Q3_Reports]) + "/" + str([No_Q4_Reports]
Once created, drag this calculated field into the Measures area, and then drop it in the Rows section. It should now display as AGG(#Reports). You can then place an appropriate label in front of this, like "Number of Reports received Q1/Q2/Q3/Q4 - ".
Hope this helps!
