-
1. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Ivan Young Mar 1, 2018 10:57 AM (in response to Jana STUPAVSKY)1 of 1 people found this helpfulHi Jana,
The reason your parameter is not working is you have "Destination name" as the value. Change it to "Destination" and the switch will work. As far as colors go, you will want to place c.Select Dimension on colors, however, you will need to set the colors yourself.
To get your table calcs to work you will need a table calc based filter. This will allow your table calcs to access the underlying data they need. The calc for date would look like LOOKUP(ATTR([Date]),0) and you would want to format it to mmmm, yyyy for your view and computing table down. Let me know if you have any questions.
Regards,Ivan
-
2. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Jana STUPAVSKY Mar 1, 2018 1:06 PM (in response to Ivan Young)Thanks, this was very helpful. Just a note, I thought "List of Values" in the parameter should list the exact name of the dimensions .... ..hmm ... Why repeating the same in "Value" and "Display as"?
Also - could I exclude Year and Month from the view in my YTD/YOY calculations, using your date table calculations?
-
3. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Ivan Young Mar 1, 2018 1:25 PM (in response to Jana STUPAVSKY)The parameter value does not need to match the dimension name. It needs to match the quoted value in the case statement.
Usually Display as and Value are the same, however you could change Display as to "Destination name" and the param would work fine.
CASE [Dimension Parameter]
WHEN "Airline" THEN [Airline]
WHEN "Destination" THEN [Destination name]
END
I'm not sure what you mean by exclude Year and Month. You can't remove either from the view as they are needed by the Table calcs, you can hide the headers if you wanted. Let me know if you have any questions.
-
4. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Jana STUPAVSKY Mar 2, 2018 8:28 AM (in response to Ivan Young)Thanks Ivan. I was able to remove Year and Month form the view. I separated my table into two sheets and built two tiles for the dashboard - one showing monthly data and YoY and the other showing YTD and YoY YTD - see image below.
However, one problem is, that the date table calculation filter in the dashboard does not give me an option to apply to multiple worksheets. Another problem is that I am unable to separate the monthly or YTD data from the %YoY numbers. As you see, I have two tiles below, I would actually like to have 4 tiles - one for each number with one single filter allowing month/year selection. Makes sense?
-
5. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Ivan Young Mar 2, 2018 5:45 PM (in response to Jana STUPAVSKY)1 of 1 people found this helpfulHi Jana,
I get what you are trying to do and understand the problem your facing. There are a couple ways to go about it. The easiest is probably to create four sheets then use a parameter to drive the filter. First you would create a parameter with dates on the 1st of the month, you can do this by clicking on the date field and going to create -> parameter.
Then create a calculated field [Date Table Calc] = [Date Parameter] which you can put on filters and set to True. You will need to add the calculated field to all 4 worksheets/tiles.
You could get a tile like effect and still keep everything in one sheet. Let me know if you need more detail.
Below is an example of all measures in a single worksheet.
-
6. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Jana STUPAVSKY Mar 8, 2018 9:20 AM (in response to Ivan Young)Ivan - brilliant! This did exactly what I was looking for. Thanks so much!
-
7. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Jana STUPAVSKY Mar 8, 2018 9:25 AM (in response to Ivan Young)Ivan - any suggestions on increase/decrease arrows you have there? I have found some tips on this subject but they seem a bit complicated.
-
8. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Ivan Young Mar 12, 2018 9:11 AM (in response to Jana STUPAVSKY)1 of 1 people found this helpfulHi Jana,
Glad this works for you. Fortunately the up down arrows are the easy part. In some cases they can be tricky, however you can use the following custom format for the percentage measures, â–² 0.00%; â–¼ -0.00%;
Let me know if you have any questions.
-
9. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Jana STUPAVSKY Mar 19, 2018 1:41 PM (in response to Ivan Young)Excellent! Thanks so much!
-
10. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Ivan Young Mar 20, 2018 8:02 AM (in response to Jana STUPAVSKY)Awesome! Glad it worked for you. When you have a chance could you close this thread? It will make it easier for future visitors to find solutions.
In fact I just answered a question about the up and down arrows and using table calcs as filters is also a solution I regularly suggest.
Thanks,
Ivan -
11. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Jana STUPAVSKY Mar 20, 2018 10:38 AM (in response to Ivan Young)Hm .. no idea where to close it ... any suggestions?
-
12. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Ivan Young Mar 20, 2018 11:31 AM (in response to Jana STUPAVSKY)I think you need to mark an answer as correct to close the thread.
-
13. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Jana STUPAVSKY Mar 20, 2018 12:56 PM (in response to Ivan Young)I did it.
Also - I am trying to build another dashboard with another type of data, utilizing the calculation [Date Tabel Calc] = [Date Parameter] you suggested earlier. But this time this T/F calculation does not give me "True" option when I move it to the filter. Any idea why?
-
14. Re: Dimension display problem when selected via Parameter & YoY YTD not displaying when using filter
Ivan Young Mar 20, 2018 1:10 PM (in response to Jana STUPAVSKY)I'm just guessing but it's probably the compute settings on your table calc.