To GoodData homepage

Topics started by Linda J

5 Topics

L
Linda JInspiring
asked in Metrics and MAQL

Date Math

Hello -I am trying to create a metric for a date last yearfor example my selected date filter is 2/01/2021 - I want the answer to be 2/01/2020 I also would like to be able to subtract months as well so 02/01/2021 would be 01/01/2021 Thank you

3
Iva Gasparekova
GoodData Employee
2 years ago
L
Linda JInspiring
asked in Metrics and MAQL

Use filter as a parameter

Hello, I would like to be able to change the metric displayed on the report based on a paramenter.For exampleA drop down box on the Dashboard has 2 possible selections A and B - only 1 can be selectedIf A is selected the formula for the metric is Z+YIf B is selected the formula for the metric is Z-Y I believe I would have to start by loading a phony table with just the values of A and B - and then add a filter onto the dashboard for the selection.  But after that I am stuck. Thanks for your help

2
L
2 years ago
L
Linda JInspiring
asked in Metrics and MAQL

Prior year calculation

Hello,I have been able to create a metric to compute prior year - but am having an issue with filtering - see screen shotI need to be able to see the prior year values for Dec, Jan and Feb  - If I ignore the parent filter I get values for all time

5
Iva Gasparekova
GoodData Employee
3 years ago
L
Linda JInspiring
asked in Metrics and MAQL

Help with Previous year calculation

Hello, I am trying to create a calculation to show the variance between the select time period (based on the dashboard filter) and the previous year.  It looks like I need to use the previous function - but I am receiving the below error.  When I use this calculation the result is always zeroSelect SalesCredit Business Line- SalesCredit Business Line where Year (Billingdatekey) = Previous   

4
L
3 years ago
L
Linda JInspiring
asked in Dashboards and Reports

Column chart How to color by group

I have a simple Column chart see below - in which I want to break down each business line by Sales region.  For Example instead of 1 bar per Business line I need 4.  Each should be a separate color.See example from another tool.  

1
Iva Gasparekova
GoodData Employee
3 years ago
Welcome to the GoodData Community!Cookie settings