Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I am having a table rows such as postID and subjectIS as primary key in the table,some has subject level and post level measures

+---------+-------------+--------------+------------+--------------+--------+
    | post.ID | post.Author | post.Replies | subject.ID | subject.Rank | year   |
    +---------+-------------+--------------+------------+--------------+--------+
    |   1     |   mike      |     10       |    movie   |     4        |  1990  |
    |   1     |   mike      |     10       |    comics  |     6        |  1990  |
    |   2     |   sarah     |      0       |    tv      |    10        |  2001  |
    |   3     |   tom       |      4       |    tv      |    10        |  2003  |
    |   3     |   tom       |      4       |    comics  |     6        |  2003  |
    |   4     |   mike      |      1       |    movie   |     4        |  2008  |
    +---------+-------------+--------------+------------+--------------+--------+

Putting measures like COUNTD(post.ID) and COUNTD(subject.ID) in rows and 'year' in column

And i want to drag MEDIAN(subject.Rank) in Color,and I am not getting a proper result

How can I improve it 

1 Answer

0 votes
by (22.5k points)

We can try by using the formula

{fixed [1st LEVEL],[2nd level]: median()}

 If you want to learn more about it Tableau, then go through this Tableau Training for more insights.    

Related questions

0 votes
2 answers
0 votes
1 answer
0 votes
1 answer
asked Dec 12, 2020 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...