Best Of
Re: How to display results up to last week
You can create a beast mode that will look at the current date and then move it back to the last day of the previous week and then compare it against your date field.
CASE WHEN `date` <= /* last day of the previous week */ DATE_ADD(DATE_SUB(CURRENT_DATE(), INTERVAL 1 WEEK) , INTERVAL (7- DAYOFWEEK(CURRENT_DATE())) DAY) THEN 'Include' ELSE 'Exclude' END
You would then drag this beast mode into your filters section and select Include.
Re: How to erase future cumulative bar lines
If you want to prevent all lines and bar from showing future dates, you can create a similar beast mode and add it to your filters like this:
- CASE WHEN `Date` < CURRENT_DATE() THEN 'Historical'
- ELSE 'Future'
- END
Drag this beast mode into your filters and filter to Historical. This will keep your chart from showing any future data.
If you want some metrics to show future and not others, then you would need to create a beast mode for each metric like the one I first gave you. If you have 12 out of 15 fields, for example, that you don't want to show future values for, you would need to create 12 different beast modes.
Hope that helps.
Re: How to erase future cumulative bar lines
You could control this by creating a beast mode for your bar values where it checks to see if the date is beyond today and make it zero or blank if it is, otherwise use the value. Something like this:
CASE WHEN `Date` < CURRENT_DATE() THEN `barvaluefield` ELSE '' END
Hope this helps.
Re: Mass Renaming Columns
Wow... just tested this on a small scale (due to there being 700+ columns browser keeps freezing on me anytime I open up that tile lol) and it worked like a charm, thank you... I will comment on here again if I end up needing more help lol @MarkSnodgrass
Jmoreno
Re: Mass Renaming Columns
One option would be for you to select the select columns tile and the tile before and then choose the "copy to clipboard" option and pasted it into a text editor. It is JSON formatted data, so you could add in all your fields in your text editor and then paste it back into Magic ETL. Here is what the select columns tile looks like in a text editor with just a single field added called "name"
{
"name": "Select Columns",
"id": "42981323-1821-44aa-835d-06815d117720",
"type": "SelectValues",
"gui": {
"x": 252,
"y": 108
},
"dependsOn": [
"e445a86c-6759-445b-a096-b4c5063e6575"
],
"removeByDefault": false,
"notes": [],
"fields": [
{
"name": "name"
}
]
}
Hope this helps.
